| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 612.1 | Contact Rdb/VMS Product Management | COOKIE::BERENSON | Words are a deadly weapon | Sat Apr 07 1990 01:45 | 4 |
| they may have an interesting answer for you.
If you want a technical answer on this, I would imagine asking in the SQL or
Rdb/VMS conference would garner more interest.
|
| 612.2 | How About Project? | BANZAI::BOOTH | What am I?...An Oracle? | Sat Apr 07 1990 23:59 | 8 |
| If the object is to just find one empty pallate, couldn't they do a
PROJECT for pallete status. That would show only one instance of
"empty". It seems like this would be an easy fix.
If the object is to find a particular pallette, they need some kind of
identifier on the rows.
---- Michael Booth
|
| 612.3 | FETCH on a cursor? | LACKEY::HIGGS | SQL is a camel in disguise | Mon Apr 09 1990 17:16 | 3 |
| You can always define a cursor, OPEN it, do a single FETCH and then close the
cursor. Do you think this is too much overhead? It certainly is not impossible.
Cursors (and not SELECT statements) are what you normally do in SQL programs.
|
| 612.4 | Sql isn't really sql if you are sybase | HENRYY::NEWMAN_SA | | Wed May 02 1990 10:09 | 14 |
| Let's assume there are 50,000 palettes that are not in use, ie free.
Now since you really don't care which one you get, Try the open
cursor, fetch, and then close versus Sybase Transelect set to one.
Sybase open cursor completes as soon as the first free palette
is found. Rdb creates a collection of 50,000 which qualify.
I will try the SQL notes file.
I agree with Michael, what good are standards if you (sybase) have
your own set.
Cheers,
Sandy
|
| 612.5 | Correction to .4 | WIBBIN::NOYCE | Bill Noyce, FORTRAN/PARALLEL | Wed May 02 1990 15:24 | 9 |
| Typically, Rdb's open cursor for such a collection will also be
quick. Rdb does not "create a collection of 50,000" unless the
query or retrieval strategy involve a sort (since that may mean
the last record encountered needs to be the first one returned).
Rather, it does enough work to get the first result, and the work
for later results will be done as needed -- or never done if you
close the cursor. What Rdb/VMS *is* missing is the ability to modify
its retrieval strategy to avoid sorting if you only need a few of
the qualifying records.
|