Need help in performance tunning for querying table [message #584836] |
Sun, 19 May 2013 07:01 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/a4be5592aefa5c2fc19a4af53c616621?s=64&d=mm&r=g) |
supiash
Messages: 70 Registered: May 2012 Location: bangalore
|
Member |
|
|
Hi,
I have an application which access couple of table and do select,update,delete,insert very often and parallely.
As the size of this table grows(no of rows), How can I maintain the response time of each of the above transactions so that my performance is not degraded.
I thought of using the indexing on the column, or there any other best methods please?
Could you help?
|
|
|
|
|
|
Re: Need help in performance tunning for querying table [message #584841 is a reply to message #584838] |
Sun, 19 May 2013 08:39 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68663 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Sorry, there was a typo (fixed), point 1 is "Do not it in PL/SQL or any loop".
The time of the output depends on 2 things: 1/ the array size the client uses, 2/ the load of each component between client and database server, including the network.
Regards
Michel
|
|
|