Ok I guess its the definition of effficient that is in question. I had assumed that Oracle would return -1 for that method but obviously wrong.
Jesse On Aug 29, 2007, at 8:52 AM, Andrea Aime wrote: > Jesse Eichar ha scritto: >> I had thought that getCount was supposed to return -1 if it can't >> fullfull the request efficiently... Or one of the methods was >> supposed to. I wonder if it is a case where uDig is using the >> wrong method or if Oracle getCount() is implemented wrong. > > None of the above I guess. > "select count(*) from xxx" is the efficient way to count > stuff in a dbms table, but it's by all means not free. > No dbms I know of keeps the count up to date in a separate table, > so it actually has to scan the primary key index to know how > many rows are there. > > Cheers > Andrea ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Geotools-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geotools-devel
