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
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
