musicales - 1:42 pm on Aug 23, 2006 (gmt 0) Does anyone know any way round this?
I'm trying to pull out ids from a table that has 5 million plus records. I'm using an ASP page and SQL server 2000. The trouble I'm having is each such query takes around 5 seconds or more, during which time the database seems to grind to a halt, slowing the rest of the site down with it.
Does anyone know any way round this?