TomBascom said:
I understood that. I was highlighting the opposite scenario. Which is all too common.
The current word is "no plan". For the last 3 or 4 years at Exchange the engine crew crows about fast table scans (and maybe mentions "SQL only" in the fine print) and the rabble at the 4GL info exchange then dutifully ask 4GL product management when it will be supported by the 4GL. Every year product management professes astonishment at the request, having never heard it before, and then duly records it on the write-only powerpoint slide. Last year Gus helpfully explained the request for product management's benefit since a great deal of confusion at this startling new need was expressed by the speaker but 10.1 has come and there is no sign of anything having changed.
This year they will probably request a "use case" (that's their latest universal product management customer control strategy) after they profess shock and amazement at this puzzling and oh so new request.
yeah. i didn't buy that story either or even took it seriously.
it's like there's a need to argue for high'er performance features ?
which are pretty common place.
and the 4gl/sql diff "mind set" doesn't apply here either.
my take on it is that they've got alot on their plate at the moment
and they're just buying time or dodging these questions.
maybe sql support for reporting tools among others are the reason
and are mostly in demand for these high end "read" features.
it's probably not easy designing for two query engines support either.
for now most of the struct enhancements are mostly for sql,
we could have gotten alot of the benefits years ago with d&l, right ?
it's worth a shot but maybe a freshly d&l v8 can compete with a type 2 db.
maybe, and if god is willing
, things will pickup
after they'll complete most of their sql engine task list.
i can think of many cases where a query that has no optimizer can go bad
and run thru half the database or atleast be very, very inefficient.
it'd be nice if the tech could take care of that for us
without us even having to know anything about it.
appreciate the info. thanks