On 21 Mar, 12:54, "Frank van Bortel" <frank.van.bor..._at_gmail.com>
wrote:
> On 20 mrt, 21:09, "Mariano" <mariano.calan..._at_gmail.com> wrote:
>
>
>
> > On 20 Mar, 20:34, Frank van Bortel <frank.van.bor..._at_gmail.com> wrote:
>
> > > Mariano schreef:
>
> > > > I really don't know where to post this message, but usually I post
> > > > here...
>
> > > > Then...
> > > > I would know, thinking in abstract level, so with no specific database
> > > > or specific programming language, in your opinion: is it possible use
> > > > 2 or more "ResultSet" to complete my work?
>
> > > > For example: I have a set of box to fillup with data obtained from a
> > > > DB, one of this box is a Menu/List item (the component with down
> > > > arrow) , in this menu appear a list of date (also date must be read
> > > > from DB). By the click of one of this data, some box of the set must
> > > > be changed.
>
> > > > My question is: should I have two query/Result set:
> > > > 1) a rs that give a list of date, that will fill up my Menu Field
> > > > 2) a rs that give all information of a specific date (this date will
> > > > be decided by Menu Field)
> > > > ???
>
> > > > I hope that I've been not so incomprehensible :D
>
> > > Sounds like *two* resultsets to me.
> > > Oracle can handle those requests rather efficient, by using bind
> > > variables - that is, your statement does not change from an
> > > Oracle perspective:
> > > select * from date_info_table where date_id = :1;
>
> > > The *value* of :1 changes, not the statement.
>
> > > The java approach would be to select all from date_info_table,
> > > store that on the application server, change the java runtime
> > > parameters into -MX1024 -MS256 or similar, and shrug when the
> > > sysops start complaining about memory usage of those darn Java
> > > apps...
> > > The date info you would need to display would be sorted, hashed,
> > > washed, rinsed and dried on the application server before it is
> > > actually displayed.
>
> > > All this because of performance.
>
> > > Yes, I've had a bad day; sysops refused to create any packages,
> > > as all 32(!) servers were running 100% CPU and swapping...
> > > --
> > > Regards,
> > > Frank van Bortel
>
> > > Top-posting is one way to shut me up...
>
> > yes, bind variables is the solution. Now... if I don't wanna do
> > complicated operations on server, the last remaining solution is to
> > make a query to fillup List with date, and another query (with bind
> > variables) to obtain info from the fields with selected date, right???
>
> Yes - don't know what front-end you use, but in
> forms you would use a when-item-changed event.
> In that event, you would fetch youe date details, based on the
> date selected in the box.
> HTML would need java(script)
I'm using Oracle and Java (using NetBeans).
Received on Wed Mar 21 2007 - 14:13:15 CDT
