Re: Using TEMP Tables

I agree dropping a table is quicker than deleting the rows, but remember to re-declare your cursors in a 4GL, or you will get a run-time that the table has been deleted, renamed or altered. ===================================================================== Paul Watje Database Something or Another watjep@hasting.com Hastings Books, Music, & Video ---------- From: ilist To: informix-list Subject: Re: Using TEMP Tables Date: Thursday, May 11, 1995 7:46PM 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. -- ---------------------------------------------------------------------------- "...so does this jelly mean we don't have to do foreplay?" ----------------------------------------------------------------------------