So I’m trying to ask this huge database questions with really simple queries and after like 8 minutes of it spinning, frozen, I didn’t know what to do. There was no way that would work. So I talked with my friend at work and he said “index it”. A dropped column or three, one new index, this was returning results. Also I reduced the database to 44 million to start getting data and it was working.
It worked right up to a “ringtones” query. Where it again took over a minute to return but when it did the count was like 15,000 something and the datagrid couldn’t handle 15,000 results. Ok, so I put in a trigger so super huge result sets need to come in .txt format with a link on the search page. This works much better.
Facebook Comments: