Kristian,
Question: Can the MySQL BLOB API access and transfer partial
blobs. That is, if you want to do the equivalent of a file *
to a BLOB table, the first 10 bytes or so of each BLOB must be
read in order to guess the type of the BLOB. Is it possible to
implement this efficiently using the
At 09:03 PM 6/19/2002, you wrote:
I am using MySQL 3.23.51 on Linux. I have a fixed-length table with 45
million rows. It appears MySQL has an efficiency issue with the LIMIT
command. When I run SELECT a FROM b LIMIT 0, 100 -- that's one
million
The query finishes almost immediately.