File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Batch statement execution - regarding Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Batch statement execution - regarding" Watch "Batch statement execution - regarding" New topic
Author

Batch statement execution - regarding

PNS Subramanian
Ranch Hand

Joined: Jul 13, 2004
Posts: 150
We use Sybase Adaptive enterprise server.

Is there any limit on the number of sql queries that can be executed using a batch statement ? Would there be a performance hit if the number of queries exceeds a certain value ?
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30382
    
150

Originally posted by PNS Subramanian:
Is there any limit on the number of sql queries that can be executed using a batch statement ?

If there is, it is so high that you wouldn't hit it in practice.

Would there be a performance hit if the number of queries exceeds a certain value ?

Yes. We've experienced this on several servers. I think it has to do with memory. We had to experiment to see where the optimal number of queries was.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Batch statement execution - regarding