[progress Communities] [progress Openedge Abl] Forum Post: Same Query Taking Different Time...

  • Thread starter Thread starter leviya
  • Start date Start date
Status
Not open for further replies.
L

leviya

Guest
I have Oracle database schema on my local machine and same schema is present on server machine as well, but time taken to execute same Query by: Server Machine : 17.45 Seconds Local Machine : 3.05 Seconds P.S : Server configuration is far much better than local machine's Configuration I have generated the explain plan from both schema's both giving almost same execution plan Explain plan local Explain plan Server Explain plan Don't know if the issue is related to Disk,CPU,I/O management ( Oracle DBA ) of the server machine. Please provide me the inputs database tuning if there are any. Thank You

Continue reading...
 
Status
Not open for further replies.
Back
Top