Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

Re: [agaffin] Why would GForum run slower on Oracle?

Quote Reply
Re: [agaffin] Why would GForum run slower on Oracle? In reply to
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.
Subject Author Views Date
Thread Why would GForum run slower on Oracle? agaffin 2335 Feb 24, 2003, 12:38 PM
Thread Re: [agaffin] Why would GForum run slower on Oracle?
Alex 2268 Feb 26, 2003, 1:11 AM
Thread Re: [Alex] Why would GForum run slower on Oracle?
agaffin 2257 Feb 27, 2003, 7:34 AM
Post Re: [agaffin] Why would GForum run slower on Oracle?
Alex 2238 Feb 27, 2003, 9:10 PM