Subject | Re: [firebird-support] Firebird, ODBC, web access and various beginner questions |
---|---|
Author | Anderson Farias |
Post date | 2007-09-18T17:44:20Z |
Hi, from my [little] experience...
it depends on your OS, what it is running besides FB and apache, what does
your app, and so forth.
I'd go with a SAS(SCSI) for the DB -- it's faster and more reliable.
and so) ... than, take a look at it
Regards,
Anderson
> Is Firebird suitable for web access? I will be accessing the databaseyes. have been using it with LAMP just great!
> from a PHP powered web application situated on a dedicated web server
> Classic or Super? I've read the papers on the subject, and it seems toOn SMP/multi-core machines Classic without doubt.
> me that I should go for Classic, seeing as I would like to fully utilize
> a multicore system. Is this assumption correct?
> How important is RAM? The databases aren't very large (a few hundredWell, RAM is always good, but you can be fine with 500MB (or less) total but
> megs total). On the Windows server it seems the Firebird instance never
> grows beyond 25-30 MB. I know from a few MySQL servers I run that RAM
it depends on your OS, what it is running besides FB and apache, what does
your app, and so forth.
> How important is harddrive speed? IDE, SATA, SCSI?Here I think it's *very* important. You can use SATA to system and apps. But
I'd go with a SAS(SCSI) for the DB -- it's faster and more reliable.
> Intel or AMD? I personally have no preference, except I tend to cheernot an issue.
> for the little guy. :o)
> OS suggestions? I plan on using Slackware, as all my other servers arethe one you're more confortable with. I personally like RedHat's ones.
> running Slack (except of course for the one Windows server discussed
> above).
> This is my very first venture into the Firebird world. Any and allMost performance issues are due to bad design (app design, sql query design,
> advice is welcome.
and so) ... than, take a look at it
Regards,
Anderson