Re: cakephp Messaging sysytem

@josh
with joins and group statements it is easier to accomplish:

function ownConversations($uid, $type = 'all') {
$options = array(
'conditions' => array('ConversationUser.status
<'=>ConversationUser::STATUS_REMOVED),
'group' => array('ConversationUser.conversation_id HAVING SUM(case
when ConversationUser.`user_id` in (\''.implode('\', \'', $uid).'\')
then 1 else 0 end) = '.count($uid).''),
'contain' => array('Conversation' => array('LastMessage')),
'order' => array('Conversation.last_message_id'=>'DESC')
);
return $this->ConversationUser->find($type, $options);
}

On 24 Feb., 12:02, "Ma'moon" <phpir...@gmail.com> wrote:
> i just have 2 points to mention for this subject:
>
> 1) If you are going to use an RDBMS to store the messages using MySQL then
> use `InnoDB` as your table engine instead of `MyISAM`
> 2) This kind of tables by nature grows faster than the most of the other
> tables in terms of records in your system, and hence you will reach a
> scalability and performance issues once this table goes for large amount of
> data, hence i would recommend considering IMAP for such a task.
>
> i have worked on such an environments before with very high traffic and very
> large amount of data and after pulling our hairs off to boost the
> performance we saw that IMAP was the best solution ever for this kind of
> tasks
>
> Ma'moon
>
> On Wed, Feb 23, 2011 at 8:08 PM, euromark <dereurom...@googlemail.com>wrote:
>
>
>
>
>
>
>
> > sure
>
> > CREATE TABLE IF NOT EXISTS `comm_conversations` (
> >  `id` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
> >  `user_id` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
> >  `title` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
> >  `created` datetime NOT NULL,
> >  `last_message_id` int(10) unsigned NOT NULL DEFAULT '0',
> >  `allow_add` tinyint(1) unsigned NOT NULL DEFAULT '0',
> >  `count` int(10) unsigned NOT NULL DEFAULT '0',
> >  PRIMARY KEY (`id`),
> >  KEY `user_id` (`user_id`)
> > ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
>
> > CREATE TABLE IF NOT EXISTS `comm_conversation_messages` (
> >  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
> >  `conversation_id` char(36) COLLATE utf8_unicode_ci NOT NULL,
> >  `user_id` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
> >  `attachment_id` int(10) unsigned NOT NULL DEFAULT '0',
> >  `message` text COLLATE utf8_unicode_ci NOT NULL,
> >  `created` datetime NOT NULL,
> >  PRIMARY KEY (`id`),
> >  KEY `user_id` (`user_id`)
> > ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
> > AUTO_INCREMENT=109 ;
>
> > CREATE TABLE IF NOT EXISTS `comm_conversation_users` (
> >  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
> >  `conversation_id` char(36) COLLATE utf8_unicode_ci NOT NULL,
> >  `user_id` char(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
> >  `status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '0=ok,
> > 1=deleted,2=removed',
> >  `last_view` int(10) unsigned NOT NULL DEFAULT '0',
> >  `created` datetime NOT NULL,
> >  PRIMARY KEY (`id`),
> >  KEY `user_id` (`user_id`),
> >  KEY `conversation_id` (`conversation_id`)
> > ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
> > AUTO_INCREMENT=110 ;
>
> > On 23 Feb., 21:31, Josh <josha...@gmail.com> wrote:
> > > Hey euromark,
>
> > > That looks like exactly what I'm trying to do.  Could you also let us
> > know
> > > what columns are in each table?  I'm sort of following your logic, but
> > not
> > > 100% and I think seeing the table columns would help a lot.
>
> > > ~Josh
>
> > --
> > Our newest site for the community: CakePHP Video Tutorials
> >http://tv.cakephp.org
> > Check out the new CakePHP Questions sitehttp://ask.cakephp.organd help
> > others with their CakePHP related questions.
>
> > To unsubscribe from this group, send email to
> > cake-php+unsubscribe@googlegroups.com For more options, visit this group
> > athttp://groups.google.com/group/cake-php

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.

To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php