RE: Using MySQL to store email

2003-02-27 Thread Vikash K Agarwal
We have used procmail and PHP combination to achieve this for our department mail management and associated workflow. Sendmail invokes procmail which delivers the mail to the normal inbox and invokes a PHP script thru LYNX The PHP script opens an IMAP connection to the inbox, reads the mail and p

resolving multiple ids in a single row from another table

2003-01-19 Thread Vikash K Agarwal
I have a table (TABLE1) which contains multiple fields for user-IDs. Some examples are - the user who created it (FLD_U1), who last updated it (FLD_U2), who is the current owner (FLD_U3) and so on. If I want to make a query and resolve all these IDs to the corresponding user-names, do I need to jo

RE: doc storage as BLOB and its search engine on MYSQL

2003-01-14 Thread Vikash K Agarwal
Thx for the correction Paul. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 10:17 PM To: Vikash K Agarwal; [EMAIL PROTECTED] Subject: Re: doc storage as BLOB and its search engine on MYSQL At 16:00 +0530 1/14/03, Vikash K Agarwal wrote

RE: Performance problems after record deletion.

2003-01-14 Thread Vikash K Agarwal
30 minutes when it used to complete in no time. Ideas to fix this is more than welcome! Best regards Gunnar Lunde > -Original Message- > From: Vikash K Agarwal [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 14, 2003 12:22 PM > To: 'Gunnar Lunde'; [EMAIL PROTE

RE: getting a page of data and total count

2003-01-14 Thread Vikash K Agarwal
Thx Adam But what if concurrent inserts are happening to the table while the users page-view thru the data. The count may change. vikash -Original Message- From: Adam Erickson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 4:48 PM To: Vikash K Agarwal; [EMAIL PROTECTED

RE: Performance problems after record deletion.

2003-01-14 Thread Vikash K Agarwal
list and subsequent INSERT operations reuse old record positions. You can use OPTIMIZE TABLE to reclaim the unused space and to defragment the data file. Rgds Vikash K Agarwal -Original Message- From: Gunnar Lunde [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 4:05 PM To

getting a page of data and total count

2003-01-14 Thread Vikash K Agarwal
need to fire two queries or is there a trick which can do this in a single query? Thx Vikash K Agarwal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

doc storage as BLOB and its search engine on MYSQL

2003-01-14 Thread Vikash K Agarwal
found a limit of 16MB for blob storage in mysql 3.2x. Is that correct and therefore shud we start development assuming a time for 4.x to be available in stable-production form. Also I m new to mailing lists so let me know if I m not in conformance of ne rules, wud gladly correct myself. Thx Vikash K