On 2011.05.31 12:54 AM, munster77054 wrote:

>
> 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.
>

Hi

I would take a look at database statistics and see what's the gap
between Generation, Oldest transaction and Oldest active .
Maybe you need to sweep your database and set sweep interval to 0 !

Regards,

--

Mercea Paul




[Non-text portions of this message have been removed]