[TYPO3-workspace] How scalable are workspaces?

[Frank Gerards]

Hi Ben,
 
> It might be an idea to join the workspaces team meeting that generally is there
> every monday, although not his last one I guess.
I don't want to take over their meeting to get my problems solved when 
they come together to talk about other things.
 
I would have been happy, if sb. would have commented my question, 
however I know that Sonja is on holiday and Tolleiv has a lot to do with 
the relaunch. So it's ok for the moment.
 
> Do you have any thoughts
> yourself on the direction that could go into? I mean solving it?
Not really. I don't know, in which context these queries are fired.
 
In the meantime, I was able to make it at least usable by shrinking down 
the tree of the WS to ~200 pages and adding another index to the pages 
table (so we're now at some seconds page generation time). Still not 
great, but it does its job.
 
If sb. from the team finds time to take a look, just get in touch with me.
 
Kind regards
Steffen
 
-- 
Steffen Gebert
TYPO3 v4 Core Team Member
TYPO3 Server Administration Team Member
 
TYPO3 .... inspiring people to share!
Get involved: http://typo3.org <http://typo3.org> 

 

 

Hi,

 

we ran into the same problem with a large site of about 30K pages. 

Steffen, could you please provide the indizes on the pages table you introduced to optimize performance ?

 

We will continue to debug that specific scalability problem and provide a patch to the community, if a solution is found.

 

 

 

Regards,

Frank Gerards

--------------------------------------------------------------------
esolut GmbH - individuelle Internet Lösungen
Internet Programmierer

Tel.: +49-89-368179.31  

 
http://www.esolut.de <http://www.esolut.de/> 
Osterwaldstr. 10, D-80805 München
Geschäftsführer: Dr. Rainer Miksch
Sitz München, HRB 123046