By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,510 Members | 1,810 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,510 IT Pros & Developers. It's quick & easy.

how to Speed up the query execution in a bulky database

P: 36
I m working on postgresql8.2.4 and struts. Earlier a report based on join queries was displayed faster. But as the no. of records go on increasing the report is not displayed completely. I tried to increase the shared_buffer parameter in postgresql.conf. But it didn't help much . Please guide me .
Its urgent.

Thanx n regards,
Aradhana
Dec 22 '09 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 700
You think the problem is database or struts (java struts I guess)?
What is the plan for that query. Maybe you should sow that query here.
Feb 21 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.