speed of inserting records into a Paradox table.
Posted on 2009-05-12
I am using Delphi7 and Paradox. My application(standalone,single user) uses mostly TTables and some TQueries. The paradox database is arranged in a master/detail relationship(several levels deep). For example table1 is master of table2 which is a master of table3 which is a master of table4 and so on.. One of the functionality of the application is to bring in backed up informations. As you keep bringing in backedup information, the application gets slower and slower. I might mention that when I bring in chunks of backed up information, most of it is inserted into lets say table4. So when the number of records in table4 gets to about 230,000 and I try to bring in the next chunk which contains about 16 to 18 thousand records for table4, the process takes about 25 minutes. The inserting of these records into table4 is done by TTable. So my question:
1) Is this speed normal of Paradpx database at this volume or is it an indication of structural and design weekness in my application and if so, what could be some strategies to speed things up?
2) My application often errors out at these volumes and the database is corrupted. I know Paradox is prone to corruption, but could these volumes also be contributing to corruption?