Thanks for the notes Guillaume. On 08/06/04, Guillaume Cottenceau ([EMAIL PROTECTED]) wrote: > Rory Campbell-Lange <rory 'at' campbell-lange.net> writes:
> > It works ok, but we have only a few hundreds/thousands of messages a > > day. For each DLR call a new database connection is created, which is > > very inefficient. > > This has been "fixed" in libsdb. > By the way, if stored procedures are that marvellous, why this > isn't used for the mysql native dlr implementation? as it seems > the vast majority of kannel users use mysql. Stored procedures are only just being adopted in MySQL. http://dev.mysql.com/doc/mysql/en/Stored_Procedures.html 20 Stored Procedures and Functions Stored procedures and functions are a new feature in MySQL version 5.0. A stored procedure is a set of SQL statements that can be stored in the server. Once this has been done, clients don't need to keep reissuing the individual statements but can refer to the stored procedure instead. ... The MySQL implementation of stored procedures is still in progress. All syntax described in this chapter is supported and any limitations and extensions are documented where appropriate. The question is, really, why are people using mysql? Rory -- Rory Campbell-Lange <[EMAIL PROTECTED]> <www.campbell-lange.net>
