Does anyone have a definitive source of information on speed issues with mysql?
I'm finding that tables containing a large blob field are incredibly slow once filled with data.
I initially though it's cause I was doing comparisons on the field containing the blob, but when I rewrote my code to use flags instead of checking for content in the blob field, it didn't solve my problem. Simple queries on the table are eating huge amounts of resources, and slowing my server to a grinding halt. Is this to be expected?
I'm finding that tables containing a large blob field are incredibly slow once filled with data.
I initially though it's cause I was doing comparisons on the field containing the blob, but when I rewrote my code to use flags instead of checking for content in the blob field, it didn't solve my problem. Simple queries on the table are eating huge amounts of resources, and slowing my server to a grinding halt. Is this to be expected?