Re: IDS Next Version - features wanted - now widely off topic

If I had a genie and had a wish left I would want only one thing in the next version of IDS...wait for it.... MARKETING.... --- Data Goob <datagoob@netscape.net> wrote: > Serge Rielau wrote: > > Data Goob wrote: > > > >> > > ROWNUMBER() OVER() does the same thing and is SQL > Standard. > > The intended feature for this kind of work are > scrollable cursors btw. > > I'm very familiar with cursors in SQL-Server, > Sybase, and Informix, > but they don't help much with web applications, at > least not that > I'm aware of. For an online application I'd have to > argue with cursors-- > but it depends on the engine. SQL-Server can be > notoriously slow with > cursors, as well as Sybase, Informix has always been > pretty fast with > them. > > > The downside of limit is that the engine has to > re-scan all the previous > > rows again and again everytime you hit next. There > is also no gurantee > > you hold position if the result set changes under > your feet. > > Web applications suffer this fate constantly. > > > Not sure which, if any of tehse features IDS > support. > > > > Cheers > > Serge > > > To be sure the LIMIT clause is not recommended for > large table usage, > but it does have a lot of uses on mid-size tables. > I've used it with > tables having a few 100K rows without any noticable > drag, and yes, > rownumber is preferred. MySQL is so darn fast > though it's hard to > really hit the wall till you get to some really > large tables. Too > bad Informix SE isn't everywhere like MySQL. > > Rob Vorbroker Phone: 513/309-1112 sending to informix-list