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@xxxxxxx [mailto:f.n.cristovao@xxxxxxx] 
 Sent: Tuesday, November 22, 2005 2:20 PM
 To: myodbc@xxxxxxxxxxxxxxx
 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@xxxxxxxxxxx