Hi,
we have installed a drupal 7 on oracle 11g enterprise edition both on windows and we are experiencing terribly slow speeds. We have setup the same drupal on both production (32gb ram windows server 2008) and devopment (3gb ram vm windows 7 pro) installations and we are experiencing the same slow speeds.
We have tried dev and stable versions of the oracle module but speeds remain the same.

If you have any thoughts or suggestions please help.

thanks,

S.

CommentFileSizeAuthor
#3 Screen Shot 2015-05-23 at 8.55.44 PM.png185.41 KBt.karkoulis

Comments

bserem’s picture

bserem commented

Could it be that something else is slowing you down? Do you have anything more to share?

Does devel report anything in the sql queries (ask from devel to display query information)

soraver’s picture

soraver commented

I have setup a clean drupal on linux on the same oracle too and i experience the same slow speeds.
When i run the queries straight on oracle i get normal speeds.

I dont see anything strange on the queries other than the slow execution times.

What else could be relevant?

t.karkoulis’s picture

t.karkoulis commented
StatusFileSize
new Screen Shot 2015-05-23 at 8.55.44 PM.png185.41 KB

Hello, is there any solutions for this?

I am attaching a screenshot of the xhprof runing on a Drupal 7 with Oracle server as the database, we are getting long loading as well, sometimes even 20 seconds. The attached screenshot is for a small page that should not take that long to respond, the web & database server are on dedicated large database and web servers.

Please note that this is not a small site, there is a number of large tables (and long tablenames). Caching is done exclusively with memcached, no database caching.

Thank you

reinaldoc’s picture

reinaldoc commented

I experience this problem too and isn't a especific query. Each query takes 5x more time than MySQL to complete.

Maybe a problem with data flush in this module or in pdo_oci.so.

bohart’s picture

bohart
Location Lutsk, Ukraine
commented
Status: Active » Closed (outdated)

D7 reached its EOL back in January 2025, and there is no active release for D7 for this module anymore.
Development or support is not planned for D7. All D7-related issues are marked as outdated in a bunch.

Everyone can apply the patches/suggestions above (not tested by the maintainers, tested by the community) to their D7 projects.
If the issue remains relevant for D10+ versions, merge requests with proposed solutions for a new module version (D10+) are welcome in a new follow-up issue.

Thanks!

Now that this issue is closed, please review the contribution record.

As a contributor, attribute any organization that helped you, or if you volunteered your own time.

Maintainers, please credit people who helped resolve this issue.