Re: timing of SQL calls and OWS

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. There is a base class that does most of the work, I guess I could paramterize its most often used SQL into prepared statments. Humm.... most of the time, I don't even know how many fields I will be selecting till runtime( it is generated by the fields of the object I am working with). Being a newbie to low-level SQL stuff....I'm not sure how to optimize this system. ~Scott } > } > greetings all, } > } > i am trying to cut down on the time it takes to transmit and recieve } > queries from our server. is there any advantage to passing statements } > 'in a group' (one right after the other)? this might not always be } > possible because the next query is depenent on the previous one, but } > there are plenty of times when i generate many statements to load in a } > order. } > } > thanks, } > } > ~Scott } > } > -- } > ________________________________________ } > Scott Ahten } > Code Wrangler } > Silent ) Planet } > scott@stage22.com } > http://www.stage22.com } > } > } > } } -- } Bill Ennis Voice: 312-474-7516 } SSA Fax: 312-474-7460 } 500 W. Madison emails: ennis@ssax.com ennis@starnetusa.com -- ________________________________________ Scott Ahten Code Wrangler Silent ) Planet scott@stage22.com http://www.stage22.com