Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: cubedwellingslave
- Order by date
-
Anyone gotten the ODBC driver to come even close to MSSQL?
1) ADO 2) Reported times *are* from the PCC :( 3) Thanks. I'll run it right now. -sdf- cubedwellingslave
- Post #5
- Forum: Pervasive: Pervasive.SQL
-
Anyone gotten the ODBC driver to come even close to MSSQL?
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...- cubedwellingslave
- Post #3
- Forum: Pervasive: Pervasive.SQL
-
PSQL is terribly slow. MSSQL - 10 sec, PSQL - 5 min!!!
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- cubedwellingslave
- Post #10
- Forum: Pervasive: Pervasive.SQL
-
Anyone gotten the ODBC driver to come even close to MSSQL?
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...- cubedwellingslave
- Thread
- Replies: 5
- Forum: Pervasive: Pervasive.SQL
