Post reply

Creat and Drop Tables

  • May 9, 2006 at 6:25 am

    #93977

    Hi,

    Am creating and deleting tables from my application. for each transaction application will create a table, after saving that entry i will drop that table.

    Is there any performance issue or any type of issues while continuesly creating and droping tables in SQL Server?

    Thansk and Regards,

    Sajan

  • May 9, 2006 at 7:37 am

    #636731

    Creating and deleting tables uses resources, of course, and this is an unusual way of designing an application.

    Whether this starts to cause you performance problems depends on volumes, hardware, how efficient your code is and no doubt many other factors.

    Have you thought instead about using a single permanent table with some sort of TransactionID (or similar) for each transaction and doing your create / delete processing using that? Sounds much more healthy to me

  • May 9, 2006 at 8:52 am

    #636773

    Do you create Temp Tables or permanent tables? I sometimes use temp tables if I have to group different ways for the query, it does take time.

    Did you try to use table-valued functions?

    Regards,Yelena Varsha

  • May 11, 2006 at 12:19 am

    #637157

    Hi,

    Thanks for your response

    Regards,

    Sajan

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply