Direct queries vs. stored procedures
View Single Post
03-31-2008, 02:48 PM
Join Date: Sep 2007
Gotta love them stored procedures...
I'm using numerous stored procedures/functions. I need them especially for the project I'm working where I work. I have a database server, MySQL, OPC server, which is integrated into our production floor, Visual Basic connector that I'm writing, which links OPC data to my database server, and PHP as a GUI. The VB connector is doing a lot of work. It's looking for updates in the OPC server and saving/sending data to/from the database. I use a lot of stored procedures in my VB app. If I didn't the VB connector would be doing a lot more work than I need it to. Right now I have 1200 lines of code for my stored procedures and functions and I expect it to keep growing.
There are 10 types of people. Those who understand binary, and those who don't. -Oldy.
View Public Profile
Send a private message to Erutan409
Visit Erutan409's homepage!
Find More Posts by Erutan409