Quote:
Originally Posted by GODPARTICLE
[You must be logged in to view images. Log in or Register.]
its a myisam table. reads are virtually 0 overhead
|
Are you forgetting all the overhead of actually running an SQL Query? The amount of code that then needs to be executed through the database functions, then the TCP code.. THEN we get to the actual mysql / myisam portion while the server process sits and twiddles it's thumbs (non asynchronous db call). Then repeat in reverse. I'll pass on that.
Quote:
Originally Posted by GODPARTICLE
[You must be logged in to view images. Log in or Register.]
especially compared to the trillions of database calls happening constantly.
|
Not on my servers. There's a reason P99 holds more stability with hundreds of people online / in same zones compared to other servers. We moved away from on-demand sql queries a long time ago, preferring caches whenever possible.