Database Query Search Time

[jarrod1937]

Instead of trying to deal with the symptoms, i'd work on the causes of them. But before anyone can help you, we'll need a bit more info. What dbms are you using? Whats your table structure like (all info if possible)? What is the exact query you're running to get the results?
I've seen some programmers try to create these crazy complex systems to attempt to deal with such slow queries (including a timeout period that kills the query) and usually the slow down is caused by an inefficient/incomplete setup on the database end. I should clarify that this is "usually" the case, at 50 million records you may have to start looking at advanced database management methods like horizontal partitioning/database sharding (though i'd need to see your database structure to see if this is applicable).