Post reply

Help in Design for performance

  • October 15, 2003 at 12:10 am

    #106640

    Hi all,

    We have a huge CSV file which is to be put into Tables. This project is a web-based project and this is not a OLTP type.

    What are the things which I should keep in mind while desiging this kind of DB for web.

    Any ideas will be appreciated.

    Thanks,

    Rahul

  • October 20, 2003 at 12:00 pm

    This was removed by the editor as SPAM

  • October 20, 2003 at 1:36 pm

    #478860

    A WEB based app is by design an OLTP app.

    You can never know how many users ar ehitting your DB.

    Therefore you have to design your DB performance in view.

    Your question is too generic to be able to answer it here but take into consideration your table and index design, also to load your huge CSV file you should use BCP with bulk logged recovery mode enabled.

    Also as advice you should remove all the indexes from the table you are bcping in. After the load you can enable them.

    But here take again care of your concurrent users!

    Bye

    Gabor



    Bye
    Gabor

Viewing 3 posts - 1 through 2 (of 2 total)

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