> [...] > > Why does MySQL needs to scan the Entire Table (all 200 MB) when I only have > > selected ID & ProductionYear in the SELECT statement ?? > > Because you have a table with variable-width records and there is no > way to easily find out where a field of a record is stored without > reading all. > > > Paradox & BDE only scans/read the selected fields. (otherwise > > Paradox would use the same amount of time of course). >
Paradox stores blob fields in another file !!! (.MB I guess) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
