Hello:
Through sql query debug flag, I've found the statement:
y = list(MySObjectThing.select().limit(1))
generates:
1. select field1, field2,... from mysqlobjectthing where 1 = 1 limit 1
2. select count(*) from mysqlobjectthing;
The second call is superfluous, silly, and in large tables, quite time
consuming.
Any ideas why it happens?
Is this a known bug, or a fixed bug, or is it a subtle 'feature' I didn't
know I might hate having to want?
Thanks,
-- Kevin
___________________________________
Kevin J. Rice
Senior Software Engineer, Textura Corporation
51-K Sherwood Terrace, Lake Bluff IL
___________________________________
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
