Slow performance XP SP1

Hi list!

I think it's worth to mention that I've upgraded the final PC from XP SP1 to SP2 and again performance has fired up from 8.5 seconds to 0.3 seconds. Impressive!

Still don't know why (suspect it could be differences from MDAC 8.0 to 8.1) but one thing's for sure: whenever I stumble on a slow SP1, moving up to SP2 will probably do the trick.

Forgot to mention that I'm using InnoDB and that I've tried other scenarios, like acessing other server on the local network which made no difference on the performance tests. Added the fact that the queries run in a flash using Query Browser in the server, I believe these are client issues.

Regards, Fernando

---------------------- MENSAGEM ORIGINAL ----------------------
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