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
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...
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.
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