Skip Menu |

This queue is for tickets about the Email-Store CPAN distribution.

Report information
The Basics
Id: 13093
Status: resolved
Priority: 0/
Queue: Email-Store
People
Owner: Nobody in particular
Requestors: nate [...] cs.wisc.edu
Cc:
AdminCc:
Bug Information
Severity: Important
Broken in: 0.24
Fixed in: (no value)

History Show all quoted text
  Sat Jun 04 22:06:59 2005 Guest - Ticket created
Subject: No foreign keys in tables
None of the Email::Store plugins use foreign keys in their tables. This really kills performance for complex queries on large databases. I don't know if this is by design or not, but if you're interested I'd be happy to send in a patch.
  Mon Jun 06 10:48:55 2005 simonw [...] cpan.org - Status changed from 'new' to 'open'
  Mon Jun 06 10:48:55 2005 simonw [...] cpan.org - Correspondence added
[guest - Sat Jun 4 22:06:59 2005]: Show quoted text
> None of the Email::Store plugins use foreign keys in their tables. > This really kills performance for complex queries on large > databases. I don't know if this is by design or not, but if you're > interested I'd be happy to send in a patch.
Omission rather than design really. I took over Email::Store from Simon Cozens and it was a bit rough and I've never really had the time to sit down and file off the edges. That plus I'm *very* out of practice with databases. Performance was going to be something I definitely I wanted to look at. Simon
  Sun Jul 23 08:10:05 2006 rjbs [...] cpan.org - Correspondence added
Patches welcome. -- rjbs
  Sun Jul 23 08:10:06 2006 rjbs [...] cpan.org - Status changed from 'open' to 'resolved'