I have a table with a blob and 13 rows in it; in the following, please notice the execution
times:
1) Selecting the primary key:
SELECT primkey from sometable
Query 1 of 1 elapsed time (seconds) - Total: 0.032, SQL query: 0.016, Building output: 0.016
2) Select the primary key with WHERE clause:
SELECT primkey from sometable WHERE someString = 'someValue'
Query 1 of 1 elapsed time (seconds) - Total: 0.843, SQL query: 0.828, Building output: 0.015
3) Here's how many rows I have:
select count(*) from sometable
13
Does the sheer fact that the table has a blob, albeit not selected, affect query execution
THAT much? Any suggestions to improve it?
Thanks