Hi,
I made a database of little pictures, which includes x und y coordinates and a blob (between 100 and 8000 bytes in size, one blob, total db size 180MB). If I do "select data from pictures where x=? And y=?" this works well, also on wince (measured myself: 1 such a select take 5 milliseconds on my wince). If I do this 100 times (to select all pictures in a rectangle), the time it needs scales linear. But If I do "select data from pictures where (x between high_x and low_x) and (y between high_y and low_y) then this takes ca. 8 seconds (!) on wince. Any idea where this long time comes from? The code is written in c++, without wrapper, page_size=512, cache=16MB and runs on a 400MHz Arm cpu. Thanks for answering, Michael
