July 31, 2010 12:24 by
andyhIf you find a select statement is doing a lot of reads when you only have a few records or one record in the table, this may be down to image data types.
I've found in SQL server i was getting 4000 + reads on a select statement to retrive 1 or 1 records
This is probably down to the image datatype which probably needs several reads across pages to retreive it.
I sped this up by changing one of the selects to not return the image as it was not needed.
e52553cb-77f2-4c60-8deb-d7dbdcd5ea93|0|.0