Re: lots of session & POST thingy

MySQL: CREATE FUNCTION I don't know the exact syntax (unfortunately the online help link to this SQL statement is broken. I would guess it's like the SQL92 standard, which you can find in documentation for other db servers. basically, you design a procedure that may take arguments (like search criteria.) in that procedure you do your insert, or your query cursor, or whatever. then from a program (php script) you call that stored procedure. the benefit is that the database server doesn't have to compile/interpret/prepare (I forget the correct name) the statement each time you use it--it's already done when you defined the procedure. that saves a lot of time and energy on the part of the server. michael --- Subhrajyoti Moitra <subhra@iitk.ac.in> wrote: > On Mon, 3 Jul 2000, Michael Teter wrote: > > > about the database performance issue with managing > > 1000 users and their cookies... > > > > write stored procedures on your database server to > do > > the creation and lookups of cookies. that will > > drastically reduce the CPU demand your database > server > > will make. > > i am using mysql database under redhat6.2 > what are these stored procedures??.. can u please > explain a bit ... or > probably if u dont have time, u can gimme a link or > two where i can > get hold of this concept .... > thanx a lot for your time ... > subhro > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: > php-general-unsubscribe@lists.php.net > For additional commands, e-mail: > php-general-help@lists.php.net > To contact the list administrators, e-mail: > php-list-admin@lists.php.net > __________________________________________________ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/