Re: RAW/RAID/2gig limit??

On Thu, 21 Sep 2000, smooth1 wrote: >What about > >- triggers Yes. Informix Guide to SQL: Syntax from December 1999 (6527.pdf) has a comment in the CREATE TRIGGER section that with XPS, you cannot create triggers on raw or static tables (which are two rather specialized table types in XPS). It clearly implies that it works on the other table types (though I have doubts about triggers on temp tables just as a general matter of course; you can't create named indexes on temp tables, so I wouldn't expect to be able to create named triggers either). >- subquery flattening Yes. The 8.3 Performance Guide (6543.pdf) explicitly says "the optimizer can unnest most correlated sub-queries ..." >- enhancements to 2 digit dates processing. It has DBCENTURY, if that's what you mean. If not, to what are you referring. >Jonathan Leffler wrote in message <39C89D10.64D46FAB@earthlink.net>... >>jrg@dbengines.com wrote: >> >>> Jonathan Leffler <Jonathan.Leffler@informix.com> wrote: >>> > On Tue, 19 Sep 2000, Don Coburn wrote: >>> > >I have Solaris 7 (Intel) with Infx 7.31. I want to >>> > >use all or most of my 128 Gig RAID Array for raw chunks. >>> > > >>> > >Am I going to hit the 2 gig limitation on chunk sizes? >>> > >>> > Yes. >>> > >>> > >If so is there a way around the limitation? >>> > >>> > Upgrade to XPS 8.31 now or wait for 9.3 (sometime later this year or >>> > early next year). >>> Hey Jonathan, so If you are running XPS 8.31 on a single node,you >>> gain big chunks and XPS's other data management goodies (not >>> to mention multi node expandability), but is there anything you give >>> up these days, that UDS 7.x can do that XPS 8.x can't? >> >>Not much that I know of, but I've not been formally briefed/trained on >>the differences between 7.31 and 8.31. If I was looking for problem >>areas, then I'd look at things like the SQL-92 syntax additions made in >>7.3x. I know XPS has CASE (and had it before IDS did). XPS now has >>blobs and stored procedures; the 8.2x and earlier versions did not. XPS >>does not support unlogged databases -- if you try a plain 'CREATE >>DATABASE xyz', the database will have a transaction log. DBD::Informix >>detects the XPS server and doesn't try to run the unlogged database test >>on it. -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"