- - Code, Content, and Presentation
- -- Databases
- ---- sql server huge collection of ids - how to query?
mattur - 12:34 pm on Apr 3, 2009 (gmt 0)
|I've always found these queries to never work right, because someone might buy things in the same session that have no relation to each other. |
As you get more data, more useful patterns emerge outweighing the unrelated data.
musicales, what are you using to run the query and what is the timeout error? Perhaps if you post your table structure, indexes and current query someone will be able to suggest a solution.
Thread source: http://www.webmasterworld.com/databases_sql_mysql/3881047.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com