Hi, every time then we are getting an object from the database (postgres) with myClass.select(myQuery) two queries are in the DB log. The first on did an "select count(*)" and the second gets the data with limit.
This is a real performance killer. Why is it so and is where a way to stop this ? As far as I know you can get the row counting after the query with psycopg. Kindly regards Lutz Steinborn 4c AG ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier. Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
