• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
DBSession becoming slow

#2
[eluser]TheFuzzy0ne[/eluser]
Do you know exactly what queries are causing the slow down? Also, have you noticed any pattern? For example, is it happening at 10 past every hour of the day? If there is a pattern, there's a chance that someone else is doing something resource intensive with their tables, and that could be causing your problem.

The Session class's query is virtually always in the same format. Each query contains between 1 and 3 very simple where clauses, so it's unlikely to be the query that's the problem, it's more likely to be the database. The only other thing I can think of is that your table is not indexed properly.


Messages In This Thread
DBSession becoming slow - by El Forum - 02-18-2009, 05:07 PM
DBSession becoming slow - by El Forum - 02-19-2009, 03:05 AM
DBSession becoming slow - by El Forum - 02-19-2009, 03:35 AM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2021 MyBB Group.