Re: Using TEMP Tables

In <3otih1$7dt@aztec.co.za> storm@aztec.co.za (Storm Software) writes: >David Chan (dwc@cix.compulink.co.uk) wrote: >: > Any extra overhead when dropping the table? >: Creating and dropping table does have an overhead so you should only do >: it once per session i.e. don't drop and recreate within an application, >: use delete instead. >I disagree about the deleting of rows. If you have a TEMP table with >a thousand rows in it, its is far quicker to discard it than to DELETE >each row. On the other hand, there's a bug (don't know a bug#, never bothered to report it) whereby if you drop & recreate the same temp table over and over, it blows up the app. This is on 5.01 online anyway. So creating the table once and just deleting/filling is the only workaround... -- Andrew Burt aburt@du.edu "Oh, what sad times are these when passing ruffians can say 'Ni' at will to old ladies."