The biggest problem rt now i m facing is that when i m running my client system, it is taking too much time for the connection and same time for fecthing the data from the database . For ex, Just for checking that if the user is valid, for connection with the server and giving the response it takes abt more than a min..... My database is not that much huge also .... So plz anyone suggest that how to improve the performance so that while connection or fetching the data it shud that some resonable time .
Some1 suggest me the create the index .. I have abt 100 tables and neither of the table i m using indexes. Suppose if its a gud idea can u suggest me that for which columns i have to create the indexes like primary key , Foreign key or anything else.
Note : I m running my application in LAN environment.
Plz give me some guide line so that i can choose some way where i have to go
Thanx in advance for helping me...
Vishal R. Methi
What database are you using?
[ July 04, 2005: Message edited by: steve souza ]
Thanx again for ur suggestion . I m using simple JDBC/ODBC connection for connection pooling. When i connect to the new and empty database its working fine with a gud speed but when i connect with my actual database with a bit heavy database, it gets very much slow. Hey could u plz tell me that when indexes doesnt increase the query fetching performance than what is the advantage of Indexes .. i dont have any idea abt the indexes ...
I hope that there is some problem with JAVA connectivity also .. can u plz suggest me how to improve the performance of the java also .
Thanx in advance again .....
Originally posted by Vishal Methi:
I m using simple JDBC/ODBC connection for connection pooling.
you didn't answer steve's question which database are you using ?
could u plz tell me that when indexes doesnt increase the query fetching performance than what is the advantage of Indexes .. i dont have any idea abt the indexes ...
How did you conclude that index doesn't increase query fetching performance.
I would recommend you read about indexes
The advantage of indexes is that it helps to find a record faster so it improves query fetching performance.
When an Index is created on one or more that columns then the column(or group of column) it represent same row. An index is stored in B-Tree form in database so it can find faster a row identification for table from B-trees mapping
I hope that there is some problem with JAVA connectivity
Go for native connectivity use type 4 driver,it imrpoves performance
Out of the problem I have one suggestion that please avoid using abbreviation, and non english word like ur,m,u,plz,thanx etc etc because It makes a post diffiucult to read, also javaranch is a place where people come who are not native english. It creates problem to read such post
I m using MAXDB which is the product of mysql.
As per your suggestion to select Type4 Driver, could you please tell me what is extra code i have to write to change the driver in database connectivity. Thanks for this suggestion . plz tell me what is the process to change the driver.
Steps are same for creating connection, load the driver , get then connection, and use connection string for type 4 connection
i dont have any idea about indexes ...
I hope that there is some problem with JAVA connectivity also
Indexes have everything to do with database performance. If your tables do not have indexes on them then any queries on a large table will be slow. I suggest you read up on them as you will never be able to write a decent database application without using them. I suspect java performance is not your problem.
Like I said run the query in a query tool and measure its performance outside of your application.