Can you post your CAs definitions? Are you trying to select everything from these tables?

>Dear Experts,
>
>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:
>
>

>Structure for table:    C:\DOCUME~1\DYLIM\LOCALS~1\TEMP\000005XL002R.TMP
>Number of data records: 26      
>Date of last update:      -  -    
>Memo file block size:   64
>Code Page:              1252    
>Field  Field Name      Type                Width    Dec   Index   Collate Nulls    Next    Step
>    1  PID             Character              10                             No
>    2  JOBORDERID      Character              32                             No
>    3  CUSTREFNO       Character              20                            Yes
>    4  LASTNAME        Character              25                             No
>    5  FIRSTNAME       Character              25                             No
>    6  MIDDLENAME      Character              25                            Yes
>    7  CAREOF          Character              50                            Yes
>    8  COMPANY         Character              50                            Yes
>    9  BUILDING        Character              50                            Yes
>   10  STREET          Character              50                            Yes
>   11  MISCADDR        Character             120                            Yes
>   12  CITY            Character              25                            Yes
>   13  ZIP             Character               4                            Yes
>   14  SPLNOTE         Memo                    4                            Yes
>   15  TXNCODE         Character               3                            Yes
>   16  TXNREFNO        Character              10                            Yes
>   17  TXNDATE         Date                    8                            Yes
>   18  STATUSCODE      Character               5                            Yes
>   19  LOCATIONID      Character              32                            Yes
>   20  REASONID        Character              32                            Yes
>   21  MESSENGERID     Character              32                            Yes
>   22  CUSTOMERID      Character              32                            Yes
>   23  PRODUCTID       Character              32                            Yes
>   24  ENTEREDBY       Character              10                            Yes
>   25  ID              Character              32                             No
>** Total **                                  722
>

>
>HELP!
>
>Thanks in advance.
>
>Dennis