Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AlessandroM
Starting Member
2 Posts |
 Posted - 2012-03-04 : 18:51:35
|
| HiI need some help for a problem that's driving me crazy!I've moved an ASP+SQLServer application from an old server to a new one.The old one was a Windows 2000 server with MSDE, and the new one is a Windows 2008 with SQL 2008 Express.Everything is ok, even a little faster, except just one damned function whose asp page gives a time out. I've tryed the query within that page in a management query windows and it never ends, while in the old server it took about 1 minute to be completed.The query is this one:SELECT DISTINCT TBL1.TBL1_ID, REPLACE(TBL1_TITOLO, CHAR(13)+CHAR(10), ’ ’), COALESCE(TBL1_DURATA, 0), TBL1_NUMERO, FLAG_AUDIO FROM SPOT AS TBL1 INNER JOIN CROSS_SPOT AS CRS ON CRS.TBL1_ID=TBL1.TBL1_ID INNER JOIN DESTINATARI_SPOT AS DSP ON DSP.TBL1_ID = TBL1.TBL1_ID WHERE DSP.PTD_ID_PUNTO = 1044 AND DSP.DSP_FLAG_OK = 1 AND TBL1.FLAG_AUDIO_TESTO=1 AND TBL1.FLAG_AUDIO_GRAFICO=’A’ AND CRS.CRS_STATO>2 OR TBL1.TBL1_ID IN (SELECT ID FROM V_VIEW1 WHERE ID IS NOT NULL AND V_VIEW1.ID_MODULO = 403721) OR TBL1.TBL1_ID IN (SELECT TBL1_ID FROM V_VIEW2 WHERE V_VIEW2.ID_PUNTO = 1044) ORDER BY TBL1_NUMERO I've tried to transform the 2 views in last lines into tables and the query works, even if a little slower than before.I've migrated the db with it's backup/restore function. Could it be and index problem?Any suggestions?Thanks in advance!Alessandro |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
AlessandroM
Starting Member
2 Posts |
Posted - 2012-03-08 : 17:10:22
|
| Thanks a lot for your replies. I got it!I've added a couple of queries to fill 2 temporary tables with the rows needed for the two "OR IN" at the end, and now it works!!:) |
 |
|
|
|
|
|
|
|
After server move a query doesn't work anymore Af