how to improve Performance
This is a discussion on how to improve Performance within the Pgsql Performance forums, part of the PostgreSQL category; --> Hi All, We r using postgresql 8.0 in our project. Our application is built in Java Swing. The Data ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-19-2008, 08:50 AM
| ||||
| ||||
 how to improve Performance Hi All, We r using postgresql 8.0 in our project. Our application is built in Java Swing. The Data is 500 mb. The application run on Server ( Xeon Dual porcessor, 2 GB Ram) , Mandrake 9.3 and 5 client terminal accessing it. But performance is not up to the mark. We have not used PL/SQL in our project. The database have around 300 tables . Queries is complicated and join r frequently used . How can we improve performance. Can we use Apache Lucene for performance.      |
Linear Mode
