I am beginning to load data exported from my old FmPro solution into Servoy (firebird) tables. I have imported the data from tab delimeted text files into “load” tables which I edit and then write various table records to the new permenant tables. I am importing files of 300 to 5000 records usually. The import process is rather quick, but the loading process which is usually a read a record, write a record method is rather slow- about 35 minutes to process 3000 records. What is worse, when I go to Delete All records in the Servoy tables to reload after a test, the delete process takes about the same amount of time. My development computer is not “state of the art”, but is not more than a few years old (Pentium 4 1,8GhZ 528M memory) and is quite adequate for other uses. I am using Developer with Windows 2000. I notice a significant amount of disk activity for each record that is processed. For example, during a Delete All records function the system seems to be touching each record individually to remove it from the database. My questions are the folowing:
- when (if) the solution is finally implemented on Servoy Server and Client, can I expect better performance than I am experiencing on Developer?
- Is there any way of performing a Delete All records that is more efficient. I would think that a more efficient way of doing this might be to select all records and then delete the entire found set in one step. I have a trial of IB Manager, and I have tried to write a procedure to delete records but have not been able to figure a way to make this work, or know if this would be more efficient.
Can anyone please shed some light on these issues? Has anyone else experienced these problems?