Hello, I was wandering what MI (7.5) does to Oracle (9.2) when querying a table in the direct mode. It seemed to be "awfully slow" up to "not working at all" for bigger tables (millions of rows).
So we eventually did a database trace on Oracle while connecting to the table. The statements that are sent to the to the database are: select * from table; ## what the hell do we need all rows for? select * from table; ## yes, better do it twice. you never know... select count(*) from table; ## ok, forgot to count during the last two selects ... after that, a statement with a nice spatial operator is used. that is how it should be. but due to the three initial selects, MI seems to be unusable with bigger tables form Oracle. anybody experienced the same porbs or even has a solution? Cheers Christof Kaiser --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9878
