Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

SQL2005 Express twice as slow as MSDE2000. How do I increase the performance of SQL Express?

Posted on 2006-11-13
3
Medium Priority
?
334 Views
Last Modified: 2012-05-05
Hi,

Since upgrading from MSDE to SQLExpress it seems that writing to the table is at least twice as slow.

I am running a P4 2.8 Ghz with 512Mb with winXP fully serviced packed.

FYI. We have an application that writes to 2 tables and when we run the app again for a fresh set of results it re-creates both tables.

Any pointers would be really helpful.


Cheers, Andy.
0
Comment
Question by:naexpert
3 Comments
 
LVL 11

Assisted Solution

by:Goodangel Matope
Goodangel Matope earned 750 total points
ID: 17929284
What are you using to connect to the database? OLEDB? ODBC?

Check indexing on your tables. If your tables are not indexed, you usually get MUCH slower performance.
0
 
LVL 28

Accepted Solution

by:
imran_fast earned 750 total points
ID: 17929303
>>Express twice as slow as MSDE2000.

In sql 2005 there is concept of schema so you should try accessing yourtable using ownername.tablename instead of tablename

select columnname from yourtablename
will be slow  as compared to
select columnname from schemaname.yourtablename
0
 

Author Comment

by:naexpert
ID: 18131215
Hi,

I think it something to do with the way our application connects to SQL. We are developing a new app so hopefully the Dev team will deal with SQL 2005 in the best possible way.

Thanks for your help/advice.

Andy
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question