[clue-tech] foreign keys in phpmyadmin

Jack Parker jack.parker4 at verizon.net
Mon Jan 30 20:08:10 MST 2006


'Hundreds of millions' is an exageration.  'tens of millions' would be more
accurate.

While I did not intend to troll, I have obviously done so - my regrets.

cheers
j.

-----Original Message-----
From: clue-tech-bounces at cluedenver.org
[mailto:clue-tech-bounces at cluedenver.org]On Behalf Of Jack Parker
Sent: Thursday, January 26, 2006 8:27 PM
To: CLUE tech
Subject: RE: [clue-tech] foreign keys in phpmyadmin


Why sir, I am gratified by your post.  I don't feel like such a troll after
all (honey?  that bridge I wanted to buy in brooklyn?  Call it off).

I am indeed an Informix >insert<, having spent many years there.  I have all
sorts of versions that I can load on my linux, 7, 8, 9, Red Brick,
Cloudscape - several of these not available to the general public.  Good
luck navigating the IBM site to find a download.  I would suggest
www.iiug.org, where (if you sign up as a member), you can download a linux
copy of 9x I believe.  If that doesn't work let me know and I'll ping
someone.

On a slightly different note, and in the 2 minutes I have left, I visited a
fortune 500 today where they are using Seibel on SQLServer.  I had the
opportunity to witness a query run, I would rate the performance as
sluggish, noticable 2second+ lag between [enter] and data.  They are also
afraid to import 11 million extra rows (they are working on <2mill now), as
they feel the database would not handle it.  For a different Fortune500
Client I have been analysing their Seibel data under Informix 9 on a dinky
single cpu dell.  I have had no issues with performance on a similar volume
of data (on a single IDE drive) and would have no problem going into the
hundreds of millions of rows on this setup.

But then as Greg pointed out, the database is a commodity at this point.
With small volumes any of them will do the trick.  For specialized needs you
might choose one over another.  When selecting, choose whatever fits your
needs.  I have to agree whole-heartedly with his post, after this reply, I
have to include the >troll< part.

cheers
j.

-----Original Message-----
From: clue-tech-bounces at cluedenver.org
[mailto:clue-tech-bounces at cluedenver.org]On Behalf Of Nate Duehr
Sent: Thursday, January 26, 2006 1:21 AM
To: CLUE tech
Subject: Re: [clue-tech] foreign keys in phpmyadmin


Jack Parker wrote:

> Must have ignored this discussion.  But as a database wonk, I should
> chime in.
>
> I've got Informix, Oracle and DB2 installed under RH7.3.
>
> Oracle was a pain to install and get working - the other day it fell
> over and I didn't feel like debugging it.  I loaded Informix on and had
> it up and running in 10 minutes.  Works great.  Db2 is rich in features,
> but not quite as snappy performance wise.

[snip]

> I prefer the Informix database, it's fast, I can tune it for OLTP or DSS
> or anything in between, if there's a performance issue, you can dig into
> it and tune it.  But then I've been using Informix for years.

What version of Informix are you using on Linux?

I kinda forgot they have a "free to use" version.  (Or do they?)

I've used it at work for years and years... virtually never dies, and
works well.

Unfortunately we're stuck on a quite old version.  The newer versions
have some nifty feature I hear.

Eventually we'll upgrade...

I may have to go get Informix for Linux and play a bit... hmm.

Nate
_______________________________________________
CLUE-tech mailing list
CLUE-tech at cluedenver.org
http://cluedenver.org/mailman/listinfo/clue-tech

_______________________________________________
CLUE-tech mailing list
CLUE-tech at cluedenver.org
http://cluedenver.org/mailman/listinfo/clue-tech

_______________________________________________
CLUE-tech mailing list
CLUE-tech at cluedenver.org
http://cluedenver.org/mailman/listinfo/clue-tech



More information about the clue-tech mailing list