Re: timing of SQL calls and OWS

Scott Ahten wrote: > Bill Ennis wrote: > > } Hi, > } > } Wouldn't it be simpler just to use a stored procedure when statements > } can be grouped? > } > } -Bill > > I have created a simple object-relational mapping framework in Java. While I > don't create tables on the fly, I do create my SQL statements from the > object's structure when I need to load and save them to the db. > Uhmm, you may want to consider if you can use ESQL/C. This would have to be a server side solution. However if you are using JDBC for a client/server (2 tier) solution, and you are using dynamic objects, you can't really improve the performance. While this sounds cryptic, it isn't. Really. :-) -Mikey BTW, The rumors concerning me and Mike Saranga are completely false. Why would I want to try and get him to do the Linux port? At the current rate of defections, there will be no one left to really do the port. I guess I had better put my call in to Leisure Suit Larry. Anyone got a quarter?