Upsizied Database to SQL 2008

[tcheck]

I upsized a 200 meg db to SQL 2008 and I noticed that the query's that have multiple OR statments is very slow coming from the SQL Server. If I have one statment it takes about 2 seconds, if I add an OR statment it takes about 2 minutes. Any solution?

[eki einstein]

Check the server location?? and offcourse check the server resource to SQL2008 it need at last 2GB RAM(no others program thats run except MSSQL it self) to works well, or check the version of your MSSQL server 2008, some version will need more RAM to run well.
and i think you need to review the database it self 200MB its quite BIG i think you need to review your database try make it not to complex and simple

hope those help

[ssanfu]

I don't think 200 meg is all that big. Access limit is 2 gig... SQL express is 4 gig... SQL Server is limited by hard drive space.

As a test, can you open the sql server management studio from your desktop? Type in the same query, first with one statement and see how long it takes to execute. Then add the OR clause and time it again.

Could be the LAN speed. It can take a lot of time to to transfer data (records) back and forth from Access to SQL on a LAN.