| Author |
 Topic  |
|
|
Morpheus73
Average Member
Denmark
597 Posts |
 Posted - 05 October 2002 : 06:13:29
|
As far as I understand you can use Stored Procedures on both MS-SQL and ACCESS platforms - soonwith v4.1 you can also on MySQL.
Wouldnīt it be an idea in the future to only rely on Stored Procedures? |
 |
|
|
bjlt
Senior Member
1144 Posts |
Posted - 05 October 2002 : 06:29:07
|
| Anybody have an idea on how much the benifit will be to use to use sp as we've already used getrows? |
 |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 05 October 2002 : 07:48:11
|
| GetRows speeds up the handling of the data by ASP and reduces the overall number of round trips to the database, SP's will speed up the retrieval of the data internally withing the DB, so you'd still be using both and should see some further speed improvements. |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
Roland
Advanced Member
Netherlands
9335 Posts |
Posted - 05 October 2002 : 08:37:31
|
| The only problem I see here is that you'd be pushing away a lot of users who are on a Unix server and don't get the latest MySQL version from their host, unless it's somehow backwards compatible and won't result in problems for pre-MySQL 4.1 users. |
|
|
|
e3stone
Average Member
USA
885 Posts |
Posted - 05 October 2002 : 09:44:36
|
| I think stored procedures should be an option; just like the database choice in the config.asp file. but, it just seems that not enough people agree. |
<-- Eric --> |
|
|
|
Morpheus73
Average Member
Denmark
597 Posts |
Posted - 05 October 2002 : 10:01:43
|
Isnīt it also a security issue - Iīve been told that Stored procedures are a lot safer regarding SQL inserts and database attacks than regular SQL.
regarding MySQL compability - I think most prviders will upgrade faily soon, since MySQL is a free product + when MySQL is Stored Procedures compatible, almost all DBīs are oracle, MS-SQL, ACCESS, DB2 - then the PHP people will switch to SP and itīll be the prevailing SQL. |
|
|
|
|
Roland
Advanced Member
Netherlands
9335 Posts |
Posted - 05 October 2002 : 10:02:49
|
I don't disagree at all. If it can be implemented and speed things up even further, great. Just as long as those people using older MySQL databases won't be left out. It's not up to the user to decide what the host installs and moving to another host just to be able to use the latest Snitz version is probably not an option for many people  |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 05 October 2002 : 15:58:30
|
You will need three different code bases. SQL Server SP's <> Access SP's <> Future MySQL SP's code. Unless something has changed recently, Access SP's are more like stored queries, because outside access you can't use program steps like you can in TSQL. MySQL probably will have Perl-like coding for SP's, similar to PostgreSQL.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 05 October 2002 : 16:20:57
|
Frankly since even MySQL 4.0 is not in release status (at least it wasn't last time I looked), seems like it will take some more time until 4.1 comes out, and even more time to get it available in many servers. So I would risk it may yet not be the time for this.
As Doug correctly stated, SP support will mean more differences between the DB's supported, which will make the code more difficult to maintain. It's not such an easy call as it may seem and the performance level of the 3.4 Snitz versions is quite impressive anyway. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Morpheus73
Average Member
Denmark
597 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 05 October 2002 : 17:12:56
|
Sorry, but I think you're wrong about that. There are differences in syntax between Access and SQL Server, for example, in the way parameters are specified. So, even if the differences are small, they exist and that's the big problem. As of now, I don't think you can even tell what will the syntax for MySQL will be, but likely it will have differences to Access and SQL Server.
Even with Access, only Jet 4.0 will support a SP syntax. Jet versions older than 4.0 won't support it. So that may bring a problem with older servers, even if I think that should not be such a big issue. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
| |
Topic |
|
Topic Locked
