Hi,
We use SAPDB 7.3 here on some terminal servers with no problem, but none
of them have 80 users logged on at one time. I haven't found the ODBC
driver to be a bottleneck though, in general. I oftentimes use SAPDB as a
temporary database for importing data from other systems that I will make
reports from, sometimes quite a lot of data, and haven't really found any
bottlenecks, other than that sometimes queries with multiple outer joins
explode and have to be made into multi-level subqueries. IF it works, the
speed is never bad.
Thank you,
Noah Silva
Atofina IS&T - Sr. Programmer Analyst
(215) 419 - 7916
[EMAIL PROTECTED]
09/10/2004 04:33 AM
To: [EMAIL PROTECTED]
cc:
Subject: maxdb- odbc driver on terminal server farm experiences ????
Hello everybody !
We want to install an application on a windows 2000 serverfarm
(terminalserver+citrix)!
The application works with the maxdb 7.5 odbc-driver against an linux
server with an maxdb 7.5 database(200 Giga).
There will be about 80 dialog users on each farmserver ! (600 users in
total)
The application does heavy interactive data processing via
sql-passthrough.
In rush hours there will be 400 users inserting,deleting and updating
two main tables with
4 million records each.
Has anybody done something like this before ??
Is the maxdb odbc driver a bottleneck ??
Is it ok to use one system dsn on each farmserver ??
Any experiences or hints welcomed
Best regards
Albert
'''''
'''''''''
(0 0)
+---------oOO-------(_)-------------------+
| Tel: 0541/5841-868 |
| Fax: 0541/5841-869 |
| Mail: mailto:[EMAIL PROTECTED] |
| Internet: http://www.piepenbrock.de |
+-------------------------------oOO-------+
|__|__|
|| ||
ooO Ooo
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
