Are you pulling all the records from the table?
BTW, why aren't you using varchar for long character columns?
>
>I have a database app tracking the delivery status of parcels. All is fine during installation and testing. I use my CA and DE classes in getting data from a MySQL database server. It has several tables like Clients, Products, Locations and transaction tables like JobOrders, ParcelTransfers, Deliveries etc.. The "heart" of it all is the Parcel table.
>
>After two weeks of field testing, the number of parcel records grew to 90,000. Two forms used then resulted in either a long long loading time which took hours on end before being shown on screen. I then traced the problem to this: any module (form) accessing the Parcel table would hang up! Even when I open the Parcel table via my CA class in the command window, it causes my VFP to show "Not Responding" error! It should be noted that when the record count was just a couple of thousands then it worked fine.
>
>If I use SQLEXEC() though, it works. Also in using the MySQL Query Browser.
>
>My question is, is there a "limit" to using the CursorAdapter? Below is the structure of the Parcel table:
>
--sb--