Re: Slow performance XP SP1

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 EUR34,90 por mês!
> Saiba mais em http://acesso.clix.pt
> grandes ideias fazem clix
>
>
>
>