[Dbmail] Dropping characters.

2002-09-24 Thread Micah Stevens
I know this isn't directly related to dbmail, but the people on the php-db mailing list aren't being too helpful and I was wondering if anyone here had any ideas. I've been having an issue where php will drop the first four characters from a POSTed form field when inserting/updating

RE: [Dbmail] Dropping characters.

2002-09-24 Thread Michael Rose, Jr.
Use phpinfo(); to figure out if the missing four characters are being lost in PHP or when you're doing the INSERT or UPDATE into mysql. Also try doing the INSERT/UPDATE via the mysql command line. Michael -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of

RE: [Dbmail] Dropping characters.

2002-09-24 Thread Micah Stevens
It's definitely something with the php interface. If I do anything at the command line, with MySQL, it works fine. I attached the phpinfo() output. I'm not sure how I'm supposed to directly use that to figure out if the characters are being lost by PHP. I did notice however, that after an

RE: [Dbmail] Dropping characters.

2002-09-24 Thread Micah Stevens
Here's the attachment. At 03:20 PM 9/23/2002 -0700, you wrote: Use phpinfo(); to figure out if the missing four characters are being lost in PHP or when you're doing the INSERT or UPDATE into mysql. Also try doing the INSERT/UPDATE via the mysql command line. Michael -Original

RE: [Dbmail] Imapd is slow as hell

2002-09-24 Thread Sam Przyswa
Hi, We have noticed that and make some tests with several Webmail and mail clients as Netscape, Outlook, vs courier-imap with the same mail clients. First conclusions the PHPs' webmails are very slow except Squirrelmail because it use its own imap libraries instead of PHP-IMAP. But it's true

RE: [Dbmail] Imapd is slow as hell

2002-09-24 Thread Micah Stevens
Just a note, on your query comments, although I'm not arguing with your basic point, it's always been my understanding that SELECT statements that use '*' instead of stating field names are slower. If you don't specify the field names the database has to spend time figuring out what they are,

[Dbmail] Amavisd-new

2002-09-24 Thread Butch Evans
I am trying to find the mailing list for amavisd-new-20020630. Anyone know where I can find a list or contact for assistance getting this program running? -- Butch Evans 573-293-2638 BPS Networks PO BOX 550 114 W Main Bernie, MO 63822

RE: [Dbmail] Imapd is slow as hell

2002-09-24 Thread Sam Przyswa
Micah Stevens ([EMAIL PROTECTED]) wrote: Just a note, on your query comments, although I'm not arguing with your basic point, it's always been my understanding that SELECT statements that use '*' instead of stating field names are slower. If you don't specify the field names the database has to

Re: [Dbmail] Imapd is slow as hell

2002-09-24 Thread Sam Przyswa
eric ([EMAIL PROTECTED]) écrivait: On Mon, 23 Sep 2002 18:48:33 -0700 in message [EMAIL PROTECTED], Micah Stevens [EMAIL PROTECTED] wrote: Just a note, on your query comments, although I'm not arguing with your basic point, it's always been my understanding that SELECT statements that use '*'

Re: [Dbmail] Imapd is slow as hell

2002-09-24 Thread Sam Przyswa
Roel Rozendaal ([EMAIL PROTECTED]) écrivait: Why use messageblks? Well, for one reason, mysql has a limit on the record size so a split-up is necessary anyway. The system was chosen to handle big messages in chunks. Ok, I guessed that there is a good reason to do that, but it's possible to use

Re: [Dbmail] Imapd is slow as hell

2002-09-24 Thread Ryan Butler
On Tue, 2002-09-24 at 10:48, Sam Przyswa wrote: Unless your program is getting back the rows as name value pairs and picking through what gets sent back, you want to be specifying the columns and the order that they are to be sent back, not asking for everything and assuming that the order

[Dbmail] dbmail and some possibilities?

2002-09-24 Thread Sing-On
Hello, community! I tried using dbmail (it`s the single thing in area loging emails), but I had some questions. 1. It`s very intresting for me to install dbmail on sendmail daemon. 2. It`s posible to put into DB not only input emails (for local users), but output email? 3. And it`s posible to

Re: [Dbmail] Imapd is slow as hell

2002-09-24 Thread Roel Rozendaal
Honestly I don't think using select fieldlist or select * is a big speed difference - it's more like the ultimate fine tuning. I think dramatic results can be achieved by developing a table layout/imap logic that minimizes the number of queries and the amount of parsing done by the imap server.