Subject | performance question |
---|---|
Author | Sudheer Palaparambil |
Post date | 2004-04-17T14:45:36Z |
Hi,
I am using some tables (like sybase's temporary
table) for report generation purpose. I usually
delete all records from the table on calling
the SP and fill the table again with the data and
return the result set.
My question is which one is best suited for FB ?
To create and drop the table each time or delete
the record each time ?
Thank you.
Sudheer
____________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html
I am using some tables (like sybase's temporary
table) for report generation purpose. I usually
delete all records from the table on calling
the SP and fill the table again with the data and
return the result set.
My question is which one is best suited for FB ?
To create and drop the table each time or delete
the record each time ?
Thank you.
Sudheer
____________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html