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