Well...
#811 posted by
metlslime on 2006/02/22 00:21:02
There is a difference between being logged in and logged out -- logged in people get a SQL query which includes their userid when visiting forum.php, while anonymous users get one that doesn't contain a userid. MySQL caches queries, so if you're not logged in, there's a good chance that your queries will have already been processed for someone who visited just before you, and so it can come out of the cache, which is a lot faster.
But this doesn't mean as much for the news page, the view_thread page, etc.
And Still
#812 posted by bambuz_unlogged on 2006/02/22 02:02:48
it fucks up most of the time, even if you're on a computer with no cookies - thus unlogged. It won't load func, either you get a zero sized reply or timeout or process limit exceeded.
Metlslime
#813 posted by
JPL on 2006/02/23 04:46:54
What's happening today ?! It's working so fast I can't remember when it happened last time... ;)
Did you change anything in your php code ?
Nevertheless, it's cool to see all is workig fine now... I hope it will be stable more than today :P
He Replaced The Hamster Wheel With A Drunken CZG
#814 posted by
. on 2006/02/23 08:16:21
Database...
#815 posted by
metlslime on 2006/03/12 22:01:48
...might be faster now. Thanks to Sleepwalkr for the tips.
Let's try it out this week and let me know how good/bad things are.
Re-Database
#816 posted by
on 2006/03/12 23:01:13
It seems quite a bit faster than it has been for some time now. But still not like it used to be, but a definite improvement over recent times, for me thus far anyway.
No Server Errors Or Anything So Far...
#817 posted by
necros on 2006/03/14 06:33:28
*crosses fingers*
maybe i can post more than just random links now ^_^
Argh!
#818 posted by Spirit on 2006/03/18 03:00:58
just had one of those recursive sql errors again?
IMPROVE'D
#819 posted by
R.P.G. on 2006/03/18 07:48:57
There has definitely been a nice improvement since the changed DB code. I have had no errors, and the site has loaded everytime I tried to access it; albeit frequently it still takes five seconds to get a response.
Well...
#821 posted by
necros on 2006/03/18 22:47:56
it's taking me quite a bit longer than 5 seconds the majority of the time (usually around 30 seconds) but it does load consistently, so that's something. thanks :)
Yay
#822 posted by
. on 2006/03/19 15:20:42
I'm actually able to open func pages in tabs without waiting forever for just the 2nd one to load.