-
DataBase location
Hi,
I have a problem with the speed of dataaccess from a access97 database. If the database is local on my machine database access is really fast, but as soon as I put it on another computer within the network and then access it, it running very slow. I know this must be a network problem but does anyone have any cleaver idears as to what I can do to improve the speed. The network is a basic 10/100 ethernet with routers
Thanks
Joolz
-
it would depend on what the SQL statement looks like. Have you created any indexes in the database tables to speed up the query searches?
-
Database
this probably answers your question but what are indexes
Joolz
-
indexes are fields in the table that hold unique information for each record...such as a ID # (a unique # for each record) or a ssn# (Social Security #) for people (not always a good idea though) look at it like this (this is a simple sample, but you should get the idea)
customer table
ID# is the index
ID# Name
1 John
2 Sam
3 Joe
if you created an SQL select statement to select all the records it would take quite some time (especially if you had 1000's of them)
but by using indexes you speed up the query by selecting specific records such as
"SELECT * FROM customer WHERE ID = '1'"
creating indexes provides a way to execute queries faster.
BTW what does your SQL statement look like? and are you getting a variable from the user? such as a date or name or something?
-
Nup the big reason as why everythings faster on a local machine is because when an access db is opened on a network drive it copies the whole db down to your local machine!
You want to make it faster use a disconnected recordset and batch updates!
later
b :)