Thank you very much for all that details.
I would to add a node because I’ll use BCA to refresh the 100 report*the n connections…
The server OS will be a Windows Server … 2000 or 2003, that doesn’t depend of me.
You’re right about the times zone… i have to consider it.
The reports are 1-3 Mo and some them are made of 400 pages.
The Sql is optimized as much as possible but sometimes queries takes a lot of time, because of the non-indexation of a DWH (https://bobj-board.org/t/52525).
I haven’t received your doc, did you send it to etienne.hovaere@laposte.net ?
Toby (BOB member since 2005-10-28)