Re: ASA9 and multiple databases: best practise?

Claus,

The databases and the number of engines aren't directly related.
However, the tasks in a server and the number of CPUs on the host are
directly related to the engines. You can't, for example affiliate a
database with an engine. You can affiliate tasks and CPUs to engines.

Think of your server as a pool of tasks (one task per connection to the
server) going to the CPUs, with the engines acting as the coordinators
or security guards blocking direct access to the hardware. You want
(and Sybase recommends) one engine per CPU so you get optimal
multitasking - since only one task per engine can be running at any
given point in time, you want to have at least one task running on each
CPU at a time. This doesn't really matter how many databases are in
your environment. Only the amount of tasks (and their respective
resource consumption) should really matter.

This is an interesting topic! I'm curious to hear what other people
have to say about this.

Hope I helped,

-Ant


Claus Scherschel wrote:
Ant Zucaro schrieb am 25.08.2006 15:06:
Claus,

Is this a question of how many databases to have per server, or how
many databases per engine (and what is easier with regards to
maintenance)?

Hi Ant,

thanks for time. No, it's not a question of the amount of databases (or,
say, the limitations of ASA9), it's a question of what to prefer: one
engine for each database or one engine driving many databases. Any why
to prefer - technically and, well, maybe legally. Admittingly, I can't
see any benefit in maintenance by having several databases in one
engine. Feel free to open my eyes.

Regards,
Claus.

.

Relevant Pages

  • info and questions on conversion to A03
    ... client databases to Jet4 and then using Access to convert to Access ... Of course, once converted, Access97 can no longer read the database. ... "Engine"? ... It bombs the first time it tries to open the ...
    (microsoft.public.vb.database.ado)
  • Re: Is MS Access A Toy?
    ... The Jet engine and the current Access 2007 DB engine that is derived from ... Jet are installed by default, and they are file-server database engines. ... Details of the difference between server and file-server databases have been ...
    (comp.databases.ms-access)
  • Re: no server engine, only local workstation engines, Status 116
    ... All the databases are version 7 due to history. ... Isn't it possible to adjust an local Pervasive engine as a LOCAL WORKSTATION ... no acception of remote requests ...
    (comp.databases.btrieve)
  • Re: ASA9 and multiple databases: best practise?
    ... Is this a question of how many databases to have per server, ... engine for each database or one engine driving many databases. ... see any benefit in maintenance by having several databases in one ...
    (comp.databases.sybase)
  • Re: Performance PSQL 10
    ... at 9.5 on a Linux Redhat ES server installation. ... We crash the SQL engine occasionally. ... environment settings, pretty much we tried everything the Pervasive ... What we REALLY need is a long enough pause and a site willing to crash ...
    (comp.databases.btrieve)