Remote view using odbc to an AS400.
Select * from myfile where keyfield = 'Somevalue'
runs sub second
gn = sqlconnect("sameDSNin remote view connection","sameid","samepass")
sqlexec(gn,"Select * from myfile where ketfield ='Somevalue'","test")
runs in 30 to 40 seconds.
both return less than 30 records.
taskmanger indicates no cpu activity on PC. I figure that means I'm waiting on the 400.
Any Ideas on where to start looking?
It's Time to get a gun.
That's what I've been thinkin.
I think I can afford one, If I do a little less Drinkin.www.TrueGeeks.com