The delays occurred on inserting data.



Dennis





_____

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Martijn Tonies
Sent: Wednesday, September 27, 2006 1:33 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] how to reduce the file size of the database
after large amount of deletes ref/eDN8072730811

> Well, the hole story is this.
>
>
>
> It is a trade application with sales with pos machines.
>
>
>
> When the database came bigger than 300mb, there are some lags during the
> day, in precise 5-10 seconds, 3 times per day, per pos machine. We can say
> that this is normal for a sql based application but too bad for pos
> machines, 5 seconds it is too much. It is about 50000 records on header
> table and 200000 on details table.
>
>
>
> For this reason I made 2 databases (files) in the same branch (shop). One

is

> the 'main' of the branch and the other one database file 'pos' for pos
> machines, these 2 databases are synchronized successfully!
>
>
>
> Now, what I want is to delete the movements from pos database and reduce
> with someway the database file to actual filesize according the records
> where holds. So the pos machines will run better as the database is almost
> empty.
>
>
>
> What do you think?

(pressed "send" too soon)

Basically, 50000 rows is just a tiny amount.

Perhaps you should explain the exact problems you are suffering.

When is this delay happening? Upon connection? Upon a certain query?

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene. <http://www.upscene.com> com
My thoughts:
http://blog. <http://blog.upscene.com/martijn/> upscene.com/martijn/
Database development questions? Check the forum!
http://www.database <http://www.databasedevelopmentforum.com>
developmentforum.com





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