Hi,
Is this a small database or a large database? If it's a large database it might be a query that Oracle is not optimizing properly, but if it's a small one, then it's most likely related to connection overhead.
I would suggest timing how long it takes to connect:
perl -MDBI -e 'DBI->connect("DBI:Oracle:host=localhost;sid=yoursid", "username", "password")'
If that's relatively quickly, try a connect, select, disconnect and compare that to mysql.
Let me know how you make out.
Cheers,
Alex
--
Gossamer Threads Inc.
Is this a small database or a large database? If it's a large database it might be a query that Oracle is not optimizing properly, but if it's a small one, then it's most likely related to connection overhead.
I would suggest timing how long it takes to connect:
perl -MDBI -e 'DBI->connect("DBI:Oracle:host=localhost;sid=yoursid", "username", "password")'
If that's relatively quickly, try a connect, select, disconnect and compare that to mysql.
Let me know how you make out.
Cheers,
Alex
--
Gossamer Threads Inc.