On Sun, 21 Apr 2002 00:54:39 +0200, Manuel Lemos wrote: > Hello, > > Richard Ellerbrock wrote: >> > If you want to hear experiences of people that tried Metabase, try >> > asking in Metabase mailing list ( >> > http://groups.yahoo.com/group/metabase-dev/ ) or BinaryCloud mailing >> > lists ( http://binarycloud.tigris.org/servlets/ProjectMailingListList >> > ). I think Alex Black (BinaryCloud project leader) has tried both >> > MySQL and Oracle with Metabase. >> >> I have done MySQL (MyISAM, INNODB), PostgreSQL and Oracle 9i with AdoDB >> - see http://iptrack.sourceforge.net. Works just fine for me. The >> hardest part was to get around limitations of certain databases - like >> Oracle does no support record count. This is not impossible to get >> around, but > > If you would have used Metabase you would not have that problem because > Metabase has a function that you may call any time after you execute a > select query that returns the number of rows contained in the result > set. That is a standard feature of Metabase that works with every > database including Oracle.
Please take a moment to also discuss the limitations in between the marketing hype - this "feature" is also not unique to your class. The Oracle driver does not support native record count (as do many other drivers, I forget which ones), so this needs to be emulated. The only way is to read in the entire result set and emulate record count. This fails for large result sets - please tell me how you intend doing this with a couple of million records? This method is also not optimal as you always land up reading the entire result set even if you do not wish to do so - a record paging application comes to mind. The only logical way is to do a select count(*) from table where ..., but this is not transaction safe. Other alternatives would be to modify your code not to depend on record count at all - this is what I did. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
