If you are using FB 1.5, the deletes may run slowly depending on what indexes or constraints you have on the work tables. If you work around it by dropping and recreating the tables, I believe you'll run out of table IDs.

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Jorge Andrés Brugger
Sent: Tuesday, November 21, 2006 6:35 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Work tables, can affect FB performance?

I want to set up work tables, which gets filled and deleted thousands of times each day (I´ve complex structures created by app, what I don't want to save at definitive tables until them are confirmed). Can this method affect FB database general performance? (internal fragmentation, for example). Do you have any suggestion about how to accomplish that, without using any memory or disk structures at client side?

Thanks!

--
Jorge Andrés Brugger
Informática
DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia Comodoro Rivadavia, Chubut, Argentina Teléfono (0297) 446-4444 int. 103 Correo electrónico: jbrugger@...
Website: www.dasu.com.ar





++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links