Drupal 7 very very slow [#2419859]

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,

Comment	File	Size	Author
#3	Screen Shot 2015-05-23 at 8.55.44 PM.png	185.41 KB	t.karkoulis

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

bserem CreditAttribution: bserem commented 4 February 2015 at 12:43

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)

Comment #2

soraver CreditAttribution: soraver commented 4 February 2015 at 12:53

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?

Comment #3

t.karkoulis CreditAttribution: t.karkoulis commented 23 May 2015 at 18:05

File	Size
Screen Shot 2015-05-23 at 8.55.44 PM.png	185.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