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

ables, 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 Sh

[SQLObject] Bind / Prepare Success (20% to 40% faster), Sample Code

50% faster) I'm not sure how people count these numbers, they could also be: 44/53 = .83 = 17% faster 101/139 = .72 = 28% faster 123/172 = .715 = 29% faster 234/352 = .665 = 34% faster Regardless, for a simple hack, this seems like it could pay some dividends... Enjoy! -- Kevin ___

Re: [SQLObject] Attempt at Implementing Bound Params inSQLObjectforget-by-id calls

ashioned way. Catch my drift? Is this silly? I'm thinking that if there's low overhead on calling back to the object's executePrepped...() method, then there's no downside to making these calls often, but it could be lots faster in the common case of a non-cached join. -- Ke

[SQLObject] Test case for bazillions of "Select...where id=val"

Name print "user's bank name is ", thisUser.bank.name print "user's bank address is ", thisUser.bank.address.printableAddress … do other stuff with thisUser. Here's the test case, should be runnable by anyone given a dsn: # test multiple

Re: [SQLObject] Attempt at Implementing Bound Params inSQLObjectfor get-by-id calls

ns. I'm interested in all opinions...? Among the user community, has anyone else turned on SQL debug and watched all the "select where.. Id=22" stuff goes by and wondered if we could speed this part up? -- Kevin ___ Kevin J. Rice Senior Software Engineer

Re: [SQLObject] Attempt at Implementing Bound Params in SQLObjectfor get-by-id calls

Select * from tableA where record id = 3 ... SQLObject is not fixing this kind of thing, it's just the way it works. So, I'm living with that. I'd just like to speed up the get by ids. I've checked, and SQLite, MySQL, and Postgres all support prepare, with seemingly the same synta

[SQLObject] Attempt at Implementing Bound Params in SQLObject for get-by-id calls

ol.dbName for col in self.sqlmeta.columnList] if not selectResults: selectResults = self._connection._SO_selectOne(self, dbNames) if not selectResults: raise SQLObjectNotFound, "The object %s by the ID %s does

[SQLObject] Apply svn:eol-style to all python files

name '*.py' | xargs svn propset svn:eol-style 'native' and then commit. So, either this is on purpose that no files have an eol-style, or wsgi_middleware has it by accident. I think it might be good to declare a standard and go with it. Or, I could be wrong, please feel free

[SQLObject] Bug with SQLBuilder's .orderBy() routine

least someone should know about it. -- Kevin Rice ___ Kevin J. Rice Senior Software Engineer, Textura LLC 51-K Sherwood Terrace, Lake Bluff IL (847) 235-8437 (spells VI

Re: [SQLObject] Confused About Caching (plus 2 feature suggestions with code)

xpense of running slightly slower (computing sizes could be done in an init and stored, but I'm not sure…) -- Kevin Rice ___ Kevin J. Rice http://justanyone.com Senior Software Engineer, Textura LLC http://texturallc.com 49-G Sherwood Terrace, Lake Bluff IL  ___