G
Guest
I apologize if this is the wrong group. I have an Access 2000 app running at
three locations (my home, my office, and my partner's home). The database
sits on an SQL Server at a "commercial" ISP site. The machines connect to
the database via ODBC with the Jet database engine. I guess the lingo is
that Access is the front end, and the SQL server is the back end.
Over the 5 years I've used this set-up, I've always been annoyed by the slow
response times. My database is extremely small, and it seems to me that for
the limited information I get out of it per query and the fact that a query
is sent to the SQL Server by somebody about once per hour, it should be
virually instantaneous.
Today I timed it as 15 seconds to make a chance in one record of one from -1
to 0. The table has 230 records and 24 columns. Most columns are either
yes/no or have only a date in them. In other words, it took 15 seconds for
ADO to do a
..find and then !field=no then .update.
I'm wondering if there is any way to improve this. Is there a better way to
run my app rather than with ODBC? Would my problem improve if I had my own
server in my office (where only the machines at home had to get data over the
internet)? Could the problem be that the ISP's server is doing too many
other things for other customers?
I'm a hobbiest, and I'm my own IT guy. (In my "real" job, I'm a doctor.) I
can't go to a main frame with Oracle, etc., but is there a "next level" out
there that I should consider moving to?
Thank you for any input.
three locations (my home, my office, and my partner's home). The database
sits on an SQL Server at a "commercial" ISP site. The machines connect to
the database via ODBC with the Jet database engine. I guess the lingo is
that Access is the front end, and the SQL server is the back end.
Over the 5 years I've used this set-up, I've always been annoyed by the slow
response times. My database is extremely small, and it seems to me that for
the limited information I get out of it per query and the fact that a query
is sent to the SQL Server by somebody about once per hour, it should be
virually instantaneous.
Today I timed it as 15 seconds to make a chance in one record of one from -1
to 0. The table has 230 records and 24 columns. Most columns are either
yes/no or have only a date in them. In other words, it took 15 seconds for
ADO to do a
..find and then !field=no then .update.
I'm wondering if there is any way to improve this. Is there a better way to
run my app rather than with ODBC? Would my problem improve if I had my own
server in my office (where only the machines at home had to get data over the
internet)? Could the problem be that the ISP's server is doing too many
other things for other customers?
I'm a hobbiest, and I'm my own IT guy. (In my "real" job, I'm a doctor.) I
can't go to a main frame with Oracle, etc., but is there a "next level" out
there that I should consider moving to?
Thank you for any input.