Subject | Re: [firebird-support] Re: 2 databases and SuperServer |
---|---|
Author | Anderson Farias |
Post date | 2008-12-30T14:59:25Z |
Hi,
shared cache should outperform the ability to use 4 cores (quad-core
processors are just "cheap" as dual-core today, no?)
I've used SS atached to 1 processor on HT, 2-core, and 4-core processors
and -- at least when it comes to Windows -- Classic is such a *huge*
diference.. lot more performing.
I'd love to hear from your experience and would be very surprised your setup
would outperform the ability of classic on SMP boxes.
Anyway... As I understand you're talking about a Web app right? I really
have little experience on it. I've deployed only 2 and both on Linux servers
running SuperServer. I gess another issue with Web apps and Classic is that
you must have a connection pool set since each user action will need to
start a new process.
Regards,
Anderson Farias
>hmm, because in classic server EACH connection will have his ownSo your expectation is that -- having to work on 2 separate databases -- a
>dedicated cache !
>i want that the 100 connections on the database 1 use the same shared
>cache and that the 20 connections on the database 2 use the same shared
>cache. as the cpu usage of both the database is 50 % i will have
>something good if i have dual cpu !
shared cache should outperform the ability to use 4 cores (quad-core
processors are just "cheap" as dual-core today, no?)
I've used SS atached to 1 processor on HT, 2-core, and 4-core processors
and -- at least when it comes to Windows -- Classic is such a *huge*
diference.. lot more performing.
I'd love to hear from your experience and would be very surprised your setup
would outperform the ability of classic on SMP boxes.
Anyway... As I understand you're talking about a Web app right? I really
have little experience on it. I've deployed only 2 and both on Linux servers
running SuperServer. I gess another issue with Web apps and Classic is that
you must have a connection pool set since each user action will need to
start a new process.
Regards,
Anderson Farias