Slow performance XP SP1

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@m.gmane.org

Re: Slow performance XP SP1

--------------070007070501040605060602
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable


Hi Fernando and hi all:

I had a similar problem, and I had asked about this problem in this=20
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=20
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@clix.pt escribi=F3:

>Hi list!
>
>Wrote an app with VC++ (7.1) using latest MyODBC (3.51.12-2) that fetche=
s 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 configura=
tion options; but these 2 other have XP SP1 (MDAC 8.0) and do not have VS=
tudio installed.
>
>None of the 3 PCs area running any other software that could take resour=
ces such as cpu, memory or disk, and they all have equivalent capabilitie=
s (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=E9 16Mb
>Apenas EUR34,90 por m=EAs!
>Saiba mais em http://acesso.clix.pt
>grandes ideias fazem clix
>
>
>
> =20
>

--------------070007070501040605060602--

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@clix.pt 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@m.gmane.org

RE: Slow performance XP SP1

Fernando,
you should add a few more details:
your API? ( VC++ refers to a compiler/linker/prg.-language)=20
your code,query,db/table-definition...
regards,armin.

> -----Original Message-----
> From: f.n.cristovao@clix.pt [mailto:f.n.cristovao@clix.pt]=20
> Sent: Tuesday, November 22, 2005 2:20 PM
> To: myodbc@lists.mysql.com
> Subject: Slow performance XP SP1
>=20
> Hi list!
>=20
> Wrote an app with VC++ (7.1) using latest MyODBC (3.51.12-2)=20
> that fetches a couple of thousands of records in less that=20
> half a second, tested on XP SP2, MDAC 8.1 running the latest=20
> server (5.0.16) on the same machine.
>=20
> Tested on 2 other machines with exact same MyODBC, Server,=20
> and configuration options; but these 2 other have XP SP1=20
> (MDAC 8.0) and do not have VStudio installed.
>=20
> None of the 3 PCs area running any other software that could=20
> take resources such as cpu, memory or disk, and they all have=20
> equivalent capabilities (memory, cpu, ...).
>=20
> The thing is: the same record fetching on the 2 SP1 machines=20
> area about 10 to 20 times slower.
>=20
> Why do you think this is happening? OS differences? Other=20
> system configs? VC++ library versions?
>=20
> Anyone else compared performance between SP1 and SP2?
>=20
> Thanks,
> Fernando
>=20
> -----------------------------------
> Telefone sem assinatura + Internet at=E9 16Mb Apenas EUR34,90 por =
m=EAs!
> Saiba mais em http://acesso.clix.pt
> grandes ideias fazem clix
>=20
>=20
>=20
> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe: =20
> http://lists.mysql.com/myodbc?unsub=3Darmin.schoeffmann@aega eon.de
>=20
>=20
>=20
>=20

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg

Re: RE: Slow performance XP SP1

OK!

API: MFC with CDatabase and CRecorset

//Begin code snippet:

CRecordset rs(theApp.GetDB());
CString sTitulo;
CString sSQL = "SELECT a.id, f.titulo FROM artigo a LEFT JOIN fornecedor f ON a.id_fornecedor=f.id ORDER BY titulo";
CDBVariant id;
rs.Open(CRecordset::forwardOnly, sSQL, CRecordset::readOnly | CRecordset::executeDirect | CRecordset::noDirtyFieldCheck);
while (!rs.IsEOF())
{
rs.GetFieldValue("id", id);
rs.GetFieldValue("titulo", sTitulo);
rs.MoveNext();
}
rs.Close();

// End code snippet

Regards
Fernando

---------------------- MENSAGEM ORIGINAL ----------------------
Fernando,
you should add a few more details:
your API? ( VC++ refers to a compiler/linker/prg.-language)
your code,query,db/table-definition...
regards,armin.

-----Original Message-----
From: f.n.cristovao@clix.pt [mailto:f.n.cristovao@clix.pt]
Sent: Tuesday, November 22, 2005 2:20 PM
To: myodbc@lists.mysql.com
Subject: Slow performance XP SP1

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@m.gmane.org