Enthuware - Best Mock Exams and Questions for Oracle Java Certifications
Quality Guaranteed - Pass or Full Refund!
No more Blub for me, thank you, Vicar.
No more Blub for me, thank you, Vicar.
Steven Squeers wrote:Sounds like you have a performance tuning problem. There are so many ways that SQL and PL/SQL (if you're using Oracle) can be optimised; is it possible that you've not exhausted the possibilities?
Enthuware - Best Mock Exams and Questions for Oracle Java Certifications
Quality Guaranteed - Pass or Full Refund!
Enthuware - Best Mock Exams and Questions for Oracle Java Certifications
Quality Guaranteed - Pass or Full Refund!
Enthuware - Best Mock Exams and Questions for Oracle Java Certifications
Quality Guaranteed - Pass or Full Refund!
How Do I Make It Run Faster?
The question in the heading is one I get asked all the time. Everyone is looking for the fast = true switch, assuming "database tuning" means that you tune the database. In fact, it is my experience that more than 80 percent (frequently 100 percent) of all performance gains are to be realized at the application design and implementation level - not the database level. You can't tune a database until you have tuned the applications that run on the database...
Note There are no silver bullets, none. If there were, they would be the default behavior and you would never hear about them...
You will only achieve large increments in performance by fixing the application, perhaps by making it do significantly less I/O.
Steven Squeers wrote:I hope though that you've also asked this question in a DBA or database forum, because this is a database issue; I'm not sure it's really got anything to do with JDBC.
Best of luck.
No more Blub for me, thank you, Vicar.
Yes, it is possible that there is scope for more optimization and we are working on it. Optimizing the current system (architecture, database structure, and queries) is one line of action that we are already working on.
What I am trying to get at is this: Is there any radically different approach that can do these kind of things better? If you were to develop an application that had similar requirement, what would you do?
Second question is, is it possible to use MySQL or PostgreSQL on a similar hardware as the one used in Exadata and achieve the same performance?
Enthuware - Best Mock Exams and Questions for Oracle Java Certifications
Quality Guaranteed - Pass or Full Refund!
Paul Anilprem wrote:
Yes, this has nothing to do with JDBC. I was looking for a database forum to post it but this was the closest I could find.
For example, if you want certain performance from your system you can either - spend money (cost of labor) and time on tuning the queries and database or you can spend money on expensive hardware (Or a combination of the two).
Steven Squeers wrote:
Paul Anilprem wrote:
Yes, this has nothing to do with JDBC. I was looking for a database forum to post it but this was the closest I could find.
Enthuware - Best Mock Exams and Questions for Oracle Java Certifications
Quality Guaranteed - Pass or Full Refund!