Goog morning / afternoon
I'm using the latest Linux MaxDB release and query it from a XP box with Delphi 7.1 through ODBC. I need to process several select queries which return about 3000 rows (10 col per row half of them are varchar(255) strings). I know I shouldn't but some people still believe they can browse more than 3000 rows at once. MaxDB seems very efficient in retrieving the datas (it takes about 0.1 s to process the query) but slow when sending them (3-4 s). I don't understand why it is so slow as :
- I'm sure the available bandwidth of my network is sufficient enough
- The XP bandwidth monitor of my box shows a max use of 12% of the 100Mb available
- The server bandwidth monitor is always under 50%
- I have not yet tryed to tweak MaxDB
- My server disks, proc and ram aren't heavily used.
Would someone know if there's a way to ehance datas transfert speed of x_server ? I don't think the well known odbc slowness is responsible of my problem. Maybe is there any tweaks I should know...
Thanks in advance. Best regards, Xavier CAMIER
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
