Re: MySQL DLR

2002-04-13 Thread Andreas Fink
>Hi Andreas, > >> For those of you who use mysql delivery reports, here's the >> definition of the standard table. I added indexes to this as >> otherwhise your system becomes suddendly very slow if you forget >> them. Happened to me with 80'000 records in the DLR database the >> speed was dr

Re: MySQL DLR

2002-04-13 Thread Stipe Tolj
Hi Andreas, > For those of you who use mysql delivery reports, here's the > definition of the standard table. I added indexes to this as > otherwhise your system becomes suddendly very slow if you forget > them. Happened to me with 80'000 records in the DLR database the > speed was dropping to 3-

MySQL DLR

2002-04-12 Thread Andreas Fink
Hello folks, For those of you who use mysql delivery reports, here's the definition of the standard table. I added indexes to this as otherwhise your system becomes suddendly very slow if you forget them. Happened to me with 80'000 records in the DLR database the speed was dropping to 3-4msg/

Re: mysql dlr fixes

2002-04-10 Thread Stipe Tolj
Andreas Fink wrote: > > >Hi Andreas, Hi others > > > >we recently changed this in gw/dlr.c: > > > >{ > > #ifdef DLR_MYSQL > > mysql_close(connection); > >-if (!mysql_errno(connection)) > >-error(0,"MYSQL: %s", mysql_error(connection)); > > #endif > > } > > > >Hmmm, don't we ne

Re: mysql dlr fixes

2002-04-10 Thread Andreas Fink
>Hi Andreas, Hi others > >we recently changed this in gw/dlr.c: > >{ > #ifdef DLR_MYSQL > mysql_close(connection); >-if (!mysql_errno(connection)) >-error(0,"MYSQL: %s", mysql_error(connection)); > #endif > } > >Hmmm, don't we need some constructs to check if the mysql_close()

mysql dlr fixes

2002-04-10 Thread Stipe Tolj
Hi Andreas, Hi others we recently changed this in gw/dlr.c: { #ifdef DLR_MYSQL mysql_close(connection); -if (!mysql_errno(connection)) -error(0,"MYSQL: %s", mysql_error(connection)); #endif } Hmmm, don't we need some constructs to check if the mysql_close() call has been su

--enable-mysql-dlr of course

2001-12-23 Thread Stipe Tolj
Ups, the typo devel striked! it's --enable-mysql-dlr of course. Stipe [EMAIL PROTECTED] --- Wapme Systems AG Münsterstr. 248 40470 Düsseldorf Tel: +49-211-74845-0 Fax: +49-211-74845-299 E-Mail: [EMAIL PROTECTED] Internet: