Comment 5 for bug 490242

Revision history for this message
Mikkel Kamstrup Erlandsen (kamstrup) wrote :

Siegfried: I can appreciate your concern with regards to query speed, but let's not put too much in it without having profiling data. I know for a fact that some DB engines check numeric bounds against their indexes, and if they are out of range simply drop the conditions from the optimized query. This would mean a slight overhead at query compile-time, but I assume that the Python sqlite module uses prepared statements which means that this cost is only a one-off...