Re: stored procedures and triggers
I have to agree here.If one doesn't know the schema and has to figure out how to locate keys in related tables, then one's not paying too much attention to the constructs of the data set. Lets not forget joins, eh? What network traffic? The list of tables? How much traffic is there in a query/result set when finding a key? The table structures? We're not talking about MB's of keys. We're talking about a couple KB's even on a very large data set. HTTP requests to the intranet server for each little graphic file will generates more chat than you'll generate with your query. The query is sent to the machine running dbms and it returns a result set. This isn't like you're using Microsoft Access or DBase/Foxpro where the query is executed by the client against a remote file forcing all that data to be transferred back and forth using a chatty protocol like NetBIOS over IP. Even though you haven't installed NetBIOS on your Win2K/XP/9n/ME box, its still there (NetBIOS over TCP/IP) and is the primary method of connection(less) between Windows machines. Even the MySQL ODBC connector uses pure TCP/IP on port 3306 non secure network? SSH is your friend. Curtis Maurand Maine Line Systems That's only if you access it directly from client. What I was talking about is AppServer sitting next to MySQL server. Preferably on the same computer. Agree that for some cascade actions triggers are very useful. But most of the folks just try to push all business logic into sp/triggers. And that's better to do in AppServer for large-scale apps. So it's strange when the initial poster said that they are core of his development. Because they shouldn't be. Yuri. Yuri. I don't agreed Yuri. triggers and sp are really useful and make the process run faster. Think on this: the user is trying to delete a record on a table. The primary key of that table is present in several other tables in the database. Before deleting the record you should search in every table for the primary key to be deleted, and if you find it the record couldn't be deleted. Well, with triggers and sp, all the job of opening every related table and look for the primary key will take place in the server, minimizing time and network traffic. Without triggers and sp, you have to manually code the process and every table you open is a request to the server and data navigating trough the network. The process is slower and more vulnerable in a non secure network. In an Internet environment triggers and sp take more importance. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: stored procedures and triggers
That's only if you access it directly from client. What I was talking about is AppServer sitting next to MySQL server. Preferably on the same computer. Agree that for some cascade actions triggers are very useful. But most of the folks just try to push all business logic into sp/triggers. And that's better to do in AppServer for large-scale apps. So it's strange when the initial poster said that they are core of his development. Because they shouldn't be. Yuri. Yuri. I don't agreed Yuri. triggers and sp are really useful and make the process run faster. Think on this: the user is trying to delete a record on a table. The primary key of that table is present in several other tables in the database. Before deleting the record you should search in every table for the primary key to be deleted, and if you find it the record couldn't be deleted. Well, with triggers and sp, all the job of opening every related table and look for the primary key will take place in the server, minimizing time and network traffic. Without triggers and sp, you have to manually code the process and every table you open is a request to the server and data navigating trough the network. The process is slower and more vulnerable in a non secure network. In an Internet environment triggers and sp take more importance. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: stored procedures and triggers
I would like to see the triggers/stored procedures/views in MySQL also. And the only estimate I saw somewhere was around version 5.0. But think about this this way: in the complex enterprise-level system you would probably need some kind of application server instead of direct client-db access. And if this is the case the need of triggers/sp is not that urgent. 3-teer system w/app server is actually the best scalable architecture. So you can do stuff that triggers/sp do in the app server where this stuff really belong. Lots of client-server projects convinced me that this approach is the best on the long run although somewhat more laborious. Yuri. Hello list, Here in my company people are concerned about which database to choose to start implementing a new application client-server. As the only person here with large experience in this field of activity is me, I am not very much inclined to our mysql due to its lack of resources like triggers and stored procedures, which are the kernel of my development. I would like to know from you if someone is in touch with the develolpment of these resources and know something about when they will be ready. And as second question I would like to know if some of you have had experience with interbase/firebird and know if it will always be a free database as well. hope you from the list are all well and healthy, yf marcello miorelli - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Stored Procedures and Triggers
On Mon, Sep 03, 2001 at 04:23:23PM +0800, Kimman Lui wrote: How many types of triggers MySQL have? And what about stored procedures? Zero and Zero, as explained in the docs. If you need them today, I'd suggest looking at PostgreSQL. If you're patient, they'll likely appear in MySQL someday--I believe both are on the TODO list. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 3 days, processed 33,335,761 queries (111/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Stored Procedures and Triggers
A friend of mine mentioned something about perl stored procedures for MYSQL. Has anyone heard about this? I have searched everywhere and only seen posts related to POSTGRESQL. If they have this for MYSQL it would be really helpful. Thanks, Dave On Mon, Sep 03, 2001 at 01:37:23AM -0700, Jeremy Zawodny wrote: On Mon, Sep 03, 2001 at 04:23:23PM +0800, Kimman Lui wrote: How many types of triggers MySQL have? And what about stored procedures? Zero and Zero, as explained in the docs. If you need them today, I'd suggest looking at PostgreSQL. If you're patient, they'll likely appear in MySQL someday--I believe both are on the TODO list. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 3 days, processed 33,335,761 queries (111/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Stored Procedures and Triggers
At 1:10 PM -0700 9/3/01, David Turner wrote: A friend of mine mentioned something about perl stored procedures for MYSQL. Has anyone heard about this? I have searched everywhere and only seen posts related to POSTGRESQL. If they have this for MYSQL it would be really helpful. That would be MyPerl: http://software.tangent.org/ It looks to be very early on in development, so I'm not sure how much I'd rely on it... -steve Thanks, Dave On Mon, Sep 03, 2001 at 01:37:23AM -0700, Jeremy Zawodny wrote: On Mon, Sep 03, 2001 at 04:23:23PM +0800, Kimman Lui [EMAIL PROTECTED] wrote: How many types of triggers MySQL have? And what about stored procedures? Zero and Zero, as explained in the docs. If you need them today, I'd suggest looking at PostgreSQL. If you're patient, they'll likely appear in MySQL someday--I believe both are on the TODO list. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 3 days, processed 33,335,761 queries (111/sec. avg) -- + Open source questions? + | Steve Edberg University of California, Davis | | [EMAIL PROTECTED] Computer Consultant | | http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ | +--- http://pgfsun.ucdavis.edu/open-source-tools.html ---+ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Stored Procedures and Triggers of MySQL
So sprach »Kimman Lui« am 2001-09-03 um 16:26:33 +0800 : How many types of triggers MySQL have? And what about stored procedures? none and (close to) none. Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 14 hours 27 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Stored Procedures and Triggers
Great thanks, I'll check it out. Dave On Mon, Sep 03, 2001 at 01:49:31PM -0700, Steve Edberg wrote: At 1:10 PM -0700 9/3/01, David Turner wrote: A friend of mine mentioned something about perl stored procedures for MYSQL. Has anyone heard about this? I have searched everywhere and only seen posts related to POSTGRESQL. If they have this for MYSQL it would be really helpful. That would be MyPerl: http://software.tangent.org/ It looks to be very early on in development, so I'm not sure how much I'd rely on it... -steve Thanks, Dave On Mon, Sep 03, 2001 at 01:37:23AM -0700, Jeremy Zawodny wrote: On Mon, Sep 03, 2001 at 04:23:23PM +0800, Kimman Lui [EMAIL PROTECTED] wrote: How many types of triggers MySQL have? And what about stored procedures? Zero and Zero, as explained in the docs. If you need them today, I'd suggest looking at PostgreSQL. If you're patient, they'll likely appear in MySQL someday--I believe both are on the TODO list. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 3 days, processed 33,335,761 queries (111/sec. avg) -- + Open source questions? + | Steve Edberg University of California, Davis | | [EMAIL PROTECTED] Computer Consultant | | http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ | +--- http://pgfsun.ucdavis.edu/open-source-tools.html ---+ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php