[TYPO3-dev] Moving pages in workspaces - brainstorm

[Dimitri Tarassenko]

Martin,

On 4/2/06, Martin Kutschker <martin.kutschker-n0spam at no5pam-blackbox.net> wrote:

> > Maybe this will sound stupid because it's so simple, but how about
> > using a separate MySQL database for each workspace?

> This may be a problem for some hosted enviroments. Not every ISP will
> allow any number of DBs.

True, however TYPO3 is already so picky about hosting environment I
would not consider this a problem. A $10/mo. account at 1&1 gives me
100 MySQL databases. The problem with TYPO3, on 1&1 that I have
experienced (a while ago, they might have fixed that) was the memory
requirements.

> Creating prefixed tables for each version is in Mysql for tables of
> myisam not desireable as the number of filehandles goes up.

We have a MySQL database that drives about 70 websites on our
derivative of MDPro. The tables for different websites that are not
shared are prefixed in the way that I am proposing. The total number
of tables in the db is around 1200-1300. Haven't had any problems so
far.

--
Dimitri Tarassenko