Slow binary data.

[Anon]

Hello all,

I am storing some images inside a Mysql db as binary data but the select which are very small querys are sooo slow that it is stalling out my scripts.. Any ideas?

thanks
peter

[jjoske]

I'm assuming that the blob types are causing the database to slow, perhaps you could move the blobs fields and just store the files as a file with the same name as a unique index. You could then just open read the files with fopen, fread etc.