|
I have been having quite a time trying to figure
this one out. I have installed PostgreSQL OLE DB drivers (ver
1.0.0.15) on two separate machines. The only difference between the
two machines is the OS, 2000 Pro (SP4) and XP Pro (SP2) and both are fully
updated from fresh installs. The PostgreSQL 8.0 server is running on
another Windows XP Pro machine (SP2, fully updated).
I am performing a Select query like
this:
SELECT column1, column2, column3 FROM table1
WHERE column4 = 'value1' AND column5 ='value2' ORDER BY column1,
column2;
Connection String:
Provider=PostgreSQL.1;Password="";User
ID=client1;Data Source=server;Location=Media Database;Extended
Properties=""
The results take approximately 2 seconds on
the XP machine and 8 seconds on the 2000 machine.
Explain Analyze yields nearly identical times
(45ms) between the two.
Any ideas why this is occuring?
Thank You,
qlawson
|
