Re: Re: Slow performance XP SP1

Thanks Josemi for pointing me to a valid direction.

Yet, that's not the problem: I had checked and no trace is running. In fact, I 
checked that the whole ODBC and database configuration are the same through all 
the computers, to the tiniest detail.

But I got some news: had to reinstall system on an SP1 PC and upgraded it to 
SP2 and voilá - best performance achieved; same results as my developing 
machine.

I will install SP2 on the remaining PC, without reinstalling the whole OS as in 
the latter case and see what comes out.

I still hope that someone with insight on MDAC, XP kernel, or C++ libraries 
colus share some knowledge on this issue.

Thank you all.
Fernando

---------------------- MENSAGEM ORIGINAL ----------------------

Hi Fernando and hi all:

I had a similar problem, and I had asked about this problem in this 
list. My problem was that with two computers the fetching rows were very 
slowly, but in others with the same configuration, etc. was pretty well. 
The problem  were  the ODBC  configuration  in  these computers (sorry 
if the names are not the same, my computer is localized in spanish) :

    * Open Control panel-system tools-odbc configuration
    * You can see diferent ---forms?? like user dsn, system dsn..... and
      one of them is 'traze'.
    * Open this form, and chek if traze is activated or no. If so, then
      this is the problem. 'Traze' save a log of plenty querys you do in
      a file in C:\SQL.LOG. Uncheck, and your querys wil go like a shot.

Regards,

Josemi

------------------------------------------
f.n.cristovao@xxxxxxx escribió:

Hi list!

Wrote an app with VC++ (7.1) using latest MyODBC (3.51.12-2) that fetches a 
couple of thousands of records in less that half a second, tested on XP SP2, 
MDAC 8.1 running the latest server (5.0.16) on the same machine.

Tested on 2 other machines with exact same MyODBC, Server, and configuration 
options; but these 2 other have XP SP1 (MDAC 8.0) and do not have VStudio 
installed.

None of the 3 PCs area running any other software that could take resources 
such as cpu, memory or disk, and they all have equivalent capabilities (memory, 
cpu, ...).

The thing is: the same record fetching on the 2 SP1 machines area about 10 to 
20 times slower.

Why do you think this is happening? OS differences? Other system configs? VC++ 
library versions?

Anyone else compared performance between SP1 and SP2?

Thanks,
Fernando


-----------------------------------
Telefone sem assinatura + Internet até 16Mb
Apenas ?34,90 por mês!
Saiba mais em http://acesso.clix.pt
grandes ideias fazem clix



-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@xxxxxxxxxxx