yes... i moved from myxpossdb.fdb to MyOffice.fdb and delete record at myxpossdb.fdb, 4 table have 50.000 record. in my data sales table  have 8000 record/day. so i will always move and delete from myxpossdb.fdb to myoffice.fdb. Just want to be my application not slow response.

--- On Mon, 2/16/09, Milan Babuskov <milanb@...> wrote:
From: Milan Babuskov <milanb@...>
Subject: Re: [firebird-support] Slow response on a big database?
To: firebird-support@yahoogroups.com
Date: Monday, February 16, 2009, 11:40 AM












Allies Xposs wrote:

> this case same with my application. but my application slow response if my table have 50.000 record :

> 1. Development with delphi 6 / client dataset

> 2. read / write 8 table run at this time and have 50 computer client

> 3. server with windows 2000, RAM 2 gb

> 4. every condition (Order by and Where SQL Statement) i create index

> every 1 month i move all recard to backup database.



Move? Does this mean to delete 50000 records in a single transaction?



--

Milan Babuskov

http://www.flamerob in.org

http://www.guacosof t.com































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