Hi. I'm still learning how to use dbExpress, after using Zeos and Delphi 5 for many years. I wrote a small program to import data from a MySQL database to another MySQL database totally different in terms of layout. It worked all right, though I'm afraid some of my clients may have tables with tens of thousands of records and it may become slow or the system resources may be depleted. I tried to use TSQLDataset instead of the trio (TSQLDataset, TDatasetProvider and TClientDataset) but with only 82 iterations and 2 inserts per iteration I get a " can't create a new thread (errno 12)...". My computer has 2GB of RAM and I'm using Delphi 2007 Professional with MySQL 5.0.45. What am I doing wrong? Is it worth to bypass TClientdataset?
Thanks in advance.