Hi everyone, I'm really hoping somebody can help me with this one.
We have a system network that holds tons of databases, all foxpro format (DBF). These databases are equipped with their own custom indexes, and are READ-ONLY. Most of them are quite large and have multiple records and fields (i.e. 3 gig in size, over 75 fields). These databases are updated on a nightly basis, for use by everyone in the morning.
I am part of a group designing software to access the information stored in these databases.
Problem is this: Access is speed is ridiculously slow.
The only way I can speed up access speed is to make a mirror of the database (which can take up to 20 minutes), add my own custom indexes (because the ones that exist are useless for our needs), and import into a .MDB format.
Important note: All of our queries may return multiple records, and are often populated into a grid-type format.
Is there any way I can use the FOXPRO source tables directly, and have the information quickly returned? I've noticed that when I perform queries which return only 1 record, I can use the SEEK method and specify an index, and the results are returned fairly quickly. But what about multiple records?
I'm using DAO, using SQL to perform all queries. I'm assuming this is one of the problems. I would obviously prefer NOT to mirror existing databases, as this is a very time consuming procedure.
Any ideas?
Thank-you very much,
Yazster
We have a system network that holds tons of databases, all foxpro format (DBF). These databases are equipped with their own custom indexes, and are READ-ONLY. Most of them are quite large and have multiple records and fields (i.e. 3 gig in size, over 75 fields). These databases are updated on a nightly basis, for use by everyone in the morning.
I am part of a group designing software to access the information stored in these databases.
Problem is this: Access is speed is ridiculously slow.
The only way I can speed up access speed is to make a mirror of the database (which can take up to 20 minutes), add my own custom indexes (because the ones that exist are useless for our needs), and import into a .MDB format.
Important note: All of our queries may return multiple records, and are often populated into a grid-type format.
Is there any way I can use the FOXPRO source tables directly, and have the information quickly returned? I've noticed that when I perform queries which return only 1 record, I can use the SEEK method and specify an index, and the results are returned fairly quickly. But what about multiple records?
I'm using DAO, using SQL to perform all queries. I'm assuming this is one of the problems. I would obviously prefer NOT to mirror existing databases, as this is a very time consuming procedure.
Any ideas?
Thank-you very much,
Yazster