Thanks for the reply.
I have a couple queries:
"SELECT * FROM UPR30300"
This table has about 80000 records and it takes about 5 minutes to return them all.
The one in my app is an ugly thing with Sums, Compound If's, 4 Inner Joins and a Group by...
2) Where would I find the DDF...
Has anyone made any progress on this?
I just landed in a P.SQL 2000i project and really need to get ODBC running something even close to MSSQL...
thread318-608331
Ok has anyone yet figured out the magic key to getting ODBC performance to come even close to MSSQL (we're using P.SQL 2000i SP3 on a Quad Xeon 2.4 Ghz w/ 2GB RAM)
Using the Btreive API would be a waste since the DB is going to be upgraded to MSSQL later this year, but the tools I'm working on...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.