A DBExpress/mysql app with 35 tables will not run on win9X twice


I will explain the subject:

We have working on an D6.02 Pro application that it has opened 35 tables. It means no problem for our dear mysql server... Nothing to our dear Delphi... Once you had accepted bugs/worarounds in mysql/dbexpress driver (auto_inc fields, libmysql.dll versions, etc...) you are happy with it... You are working in Windows XP Professional w/ mysql on Debian Woody and no issue on working table...

?Where is the problem?: You know mysql/dbx driver clone sqlconnection each you open a dataset (we use TSQLClientDataSet). Only one query on a thread... Well, no problem: while Borland guys fix this problem our app should increase bandwidth use, but...

What a surprise when we deploy our first test copy of our program. Our tester has Windows 95 installed on system, and literally from mysql manual:

"The maximum number of connects MySQL is depending on how good the thread library is on a given platform. Linux or Solaris should be able to support 500-1000 simultaneous connections, depending on how much RAM you have and what your clients are doing." ( URL : http://www.mysql.com/documentation/mysql/bychapter/manual_Problems.ht... )

Maybe on Win95/98 the thread library is very "short" or maybe MS didnt expect that you have to connect to a win9X around 100 network connections (as it occurs if you have only THREE (3) clients running same time at other workstations on the lan): 3 Connections + 35 Tables ~= 100 server connections/threads.

This is not a mysql limitation: Weve tried changing EVERY mysql variable possible (weve lost such develop time!!... <snif> :_( . It sounds like Windows 9x should not to have so many connections opened, but we only have 3 clients apps running !!!!!

This is a consecuence (should I write spanish word "consecuencia" this way?? ;) of the well known bug of mysql/dbexpress driver.

Thanks a lot for your time and patience (my english sounds really bad xD )

Manuel Mu?oz
Sistemas 2000