On Jan 25, 2010, at 7:02 PM, JohnS jses27@gmail.com wrote:
On Mon, 2010-01-25 at 18:51 -0500, Ross Walker wrote:
Instead look at the way your PHP Code is Encoding the BLOB Data and if your really need the speed since now it's MySQL DB, make you own custom C API for mysql to encode the BLOB. The DB can do this like that much faster then your PHP app ever thought of.
I believe the OP said he was running postgresql.
Quoted from OPs previous mail hes not sure lol....
"""The web application is written in PHP and runs off MySQL and/or Postgresql."""
Ah, well #1 on his list then is to figure out what he is running!
If there are BLOB/TEXT fields those should really be queried separately and put in some cache shared by the PHP app (or discarded depending on how frequently used). Not knowing what they are, probably avatars, which should be cached, as opposed to uploads or such which shouldn't. Who knows without more info.
-Ross