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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Crating Stored Procedure in PCC
- Thread starter boriska40
- Start date
ar1 and WHy do you need a Stored Procedure? There is no performance gain by using a Stored Procedure with Pervasive.SQL. You can issue just a Select statement. It would be something like:
select * from table where fld1 between PAR1 and PAR2
The fieldlist could also be set within the statement. If you're doing this in code, the values of PAR1 and PAR2 can be set to anything that matches the data type of fld1.
info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician
select * from table where fld1 between PAR1 and PAR2
The fieldlist could also be set within the statement. If you're doing this in code, the values of PAR1 and PAR2 can be set to anything that matches the data type of fld1.
info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician
- Thread starter
- #3
mirtheil, thanks for your response.
One of our clients is using Macola 7.6 and Access XP.
He is using old Pervasive 32-bit driver.
Some of the tables are huge (more than 100000 records).
Access queries (based on linked tables) run >=45 min. I'd like to test it using stored procedures and Pervasive ODBC Engine/Client interface.
One of our clients is using Macola 7.6 and Access XP.
He is using old Pervasive 32-bit driver.
Some of the tables are huge (more than 100000 records).
Access queries (based on linked tables) run >=45 min. I'd like to test it using stored procedures and Pervasive ODBC Engine/Client interface.
Again, using a Stored Procedure will not gain any performance. A Stored Procedure is really more of a stored statement. There is no pre-compilation of a Stored Procedure. You would do better to optimize the SQL statement. I only say this to save you time and effort.
Are the Access queries Pass Through? If not, that might help with performance. Also, what are the queries? Post them and maybe we can help.
info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician
Are the Access queries Pass Through? If not, that might help with performance. Also, what are the queries? Post them and maybe we can help.
info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician
Boriska40,
I would write a crystal report for this. If you use the proper indexes and the record selection formula for the report passes thru to the SQL statement in crystal, the performance should be much better than this.
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
I would write a crystal report for this. If you use the proper indexes and the record selection formula for the report passes thru to the SQL statement in crystal, the performance should be much better than this.
Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
- Status
Similar threads
- Locked
- Question
- Question