How to improve performance on CREATE DATABASE statement

Discussion in 'Databases' started by kammi_b, Mar 5, 2009.

0
  1. #1
    Hi All,

    I have an issue and am hoping someone can help me.

    I am working on a real time app which involves SQL Express 2005.

    My issue is that the app creates databases on the fly as information is being passed to the server, and they are taking alot of time to be created. Curretnly it takes between 250ms-500ms for a database to be created. I need it to take no more than 150ms.

    I am using the CREATE DATABASE statement in ADO C++.

    Does anyone have any ideas as to how I can speed this up please?

    Any help is much appreciated.

    Thanks
     
    kammi_b, Mar 5, 2009 IP
  2. alexpr07

    alexpr07 Active Member

    Messages:
    284
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    73
    #2
    Sorry, I wish I could help you but this is out of my expertise. But creating a whole database in 250ms is not so bad... One solution: If you want to improve performance, just get a faster database server...
     
    alexpr07, Mar 5, 2009 IP
  3. OinkOink

    OinkOink Peon

    Messages:
    39
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    There are no "speed up" techniques for the CREATE DATABASE stakement. Depending on how important it is I would advise you upgrade your database server faster CPU and faster Hard Drive.
     
    OinkOink, Mar 9, 2009 IP
  4. chisara

    chisara Peon

    Messages:
    141
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Am I correct in reading that you want to create databases depending on the data that you inspect / analyze.
    That would imply that you are using the database name to store data, it is usually best to store data in the records/tuples instead of the database or table names.

    PLease explain you problem in more detail so a better alternative might be given
     
    chisara, Mar 12, 2009 IP