[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sapdb-general
Subject:    RE: Performace with lots of databases on one server
From:       "Dittmar, Daniel" <daniel.dittmar () sap ! com>
Date:       2006-08-31 16:50:33
Message-ID: AF2DBDAE7523734B8E8FDC3EAE6BCCE703D54DBE () dewdfe23 ! wdf ! sap ! corp
[Download RAW message or body]

> We are running a shop engine (build in perl) that uses MaxDB as its 
> database. At one of our customers the system uses a single 
> database-instance for about 120 shops utilizing a model like SAP does 
> (client-dependent and client-independent tables).

Try using schemas. 

- Create one SCHEMA per shop
- create all the tables, indices and views in each schema
- when you get the session from the session pool, execute SET
CURRENT_SCHEMA = <schema name of current shop>
- if you have shared tables, you can probably create them in a special
schema and then create SYNONYMs in all the shop schemas

The remainder of your code can then ignore the problem. I hope that
Hibernate does. If they generate SQL statements with fully qualified
table names, then some tweaking is in order. OK, tweaking might be an
euphemism.

Daniel Dittmar

-- 
Daniel Dittmar
MaxDB, SAP Labs Berlin
daniel.dittmar@sap.com 


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=sapdb-general@progressive-comp.com


[prev in list] [next in list] [prev in thread] [next in thread]