On Jan 25, 2010, at 7:02 PM, JohnS <jses27 at 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