Re: Queries slow down daily, optimizing helps -> why?
Posted by:
aftab khan
Date: February 27, 2009 04:21AM
>Ok you are using the index on "user", but it is only about 100K (4 byte key + 4 >byte pointer, times 11K rows, + overhead).
Hi, James. you are right, I didn't do this calculation. Indeed my comments on this doesn't apply.
Subject
Views
Written By
Posted
4484
February 18, 2009 04:54AM
2293
February 18, 2009 09:04AM
2389
February 18, 2009 11:57AM
2380
February 19, 2009 01:00AM
2332
February 19, 2009 01:52AM
2347
February 19, 2009 03:32AM
1777
February 19, 2009 05:08AM
2221
February 19, 2009 12:24PM
2308
February 19, 2009 10:53PM
2424
February 20, 2009 08:34AM
2202
March 18, 2009 03:58AM
2320
February 21, 2009 06:15AM
2273
February 24, 2009 10:02AM
2484
February 26, 2009 02:30AM
2106
February 26, 2009 09:56AM
2297
February 26, 2009 08:14PM
2315
February 27, 2009 01:38AM
2200
February 27, 2009 07:56PM
2202
February 28, 2009 06:20AM
2529
February 28, 2009 03:43PM
Re: Queries slow down daily, optimizing helps -> why?
2322
February 27, 2009 04:21AM