OK, I need some advise. In 2008, I wrote a program, using at that time the most current version of FB. Since then, I left it as is, and didn't do anything with it, until now. Now, I'm updating it, and I currently have FB 2.1.3.18185 installed, but I'm going to try 2.5 now.

Now here is the situation. In 2008, using the FB, when I processed the file, it went fast, and was able to process 3000+ records in about 20 seconds... it was reading a flat file, parsing it, and putting it into the database.

I tried it earlier today, with the same DB from 2008, and it only processed about 50 records in the same time that in 2008 it took to process 3000+ records, and later, it slowed down even more. I rebuilt the database/tables, and tried it again, and the 20 seconds came back. Can anyone tell me why? It is my understanding, that when I opened the old database with FB 2.1.3.18185, it was suppose to convert it to the current format. Any ideas?

BTW, the program was written in Borland C++ 2006, and the OBJ and EXE files were deleted, and the program recompiled, and that didn't help! But as said above, when I recreated the DB and tables, it worked fine. I just want to know of any ideas you fine folks might have, for future reference.

Thanks.

I'll be off-line for the rest of the day and tomorrow for the biggest part... it's the monthly trip in town.