Mailinglist Archive: opensuse (2358 mails)

[rachel@xxxxxxxxxxxxxx (Rachel Greenham)]

S Jackson wrote:
> 
> I am looking to implement a database solution with an HTML interface
> (provided by Apache of course) on Linux.  Does anyone have a database
> recommendation?  Any success stories?  Any failures?  What's the best
> one to use for databases ranging from 100,000 records to 10,000,000
> records?  I'd appreciatte ya'lls comments.  Thanx

I use Postgresql, which is available on SuSE 6.2, but I've upgraded my
Postgres to 6.5.2 (SuSE comes with 6.4 I think). I haven't taken it up to the
upper range you're asking after, but I don't doubt it can do it. It's very
solid indeed, but you need to be aware of the tricks you need to play to get
good performance: (Good index design, vacuum it regularly).

FYI my server context is that I use JSP and servlets, and thus JDBC to talk
to Postgresql.


-- 
Rachel

-- 
To unsubscribe send e-mail to suse-linux-e-unsubscribe@xxxxxxxx
For additional commands send e-mail to suse-linux-e-help@xxxxxxxx             
Also check the FAQ at http://www.suse.com/Support/Doku/FAQ/