[SQLObject] Extra select count(*) being run for no apparent …

Top Page
Author: Kevin J. Rice
Date:  
To: sqlobject-discuss
Subject: [SQLObject] Extra select count(*) being run for no apparent reason ...

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@???
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss