Re: [Tutor] Sloooooow SQL

2007-03-30 Thread Tim Golden
Øyvind wrote: > I have been writing some scripts that gets data from a MSSQL-database. > However, it is very slow. If I use the script, the retrieving of data and > displaying in html takes close to 30 seconds. If I use the SQL Server > Management Query, the same query takes a second or two. Why th

[Tutor] Sloooooow SQL

2007-03-30 Thread Øyvind
Hello. I have been writing some scripts that gets data from a MSSQL-database. However, it is very slow. If I use the script, the retrieving of data and displaying in html takes close to 30 seconds. If I use the SQL Server Management Query, the same query takes a second or two. Why this enormous di