>Hello Everybody!
>
>I have about 100 tables in a my dabase container. I access these table over the network via Vfp ODBC (Newest version). Only on my customer table which has only 3000 reocrds, it takes literally 2 minutes to requery one record. Other tables have 800,000 records and it takes less than a minute to requery all records.
>
>The customer table has an index on the CUS_NUMB field. Below is a sample code I use:
>
>vp_cus_numb = "XYZ"
>SELECT customer
>=requery()
>
>Does anyone have some idea what is going on... Please help!!!!!!
>
>
>Thank You In Advance!
>
>
>Raza Malik
Hi Raza
What database is behind ODBC?
If you are having VFP database accessed via ODBC then speed will always be your problem. In case you deploy MS-SQL or some other database at the back then things will be improved. Also developing Client/Server apps has to be tuned for performance. So you should always request some subset of data
instead of whole table. You said that you have 100 tables ? Did you consider spliting it into more then one database? Because with all tables and views
your DBC container itself could be very 'heavy'.
Good luck :-))