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.flamerobin.org
http://www.guacosoft.com