[Kde-pim] Akonadi: single database design mistake?

[Milian Wolff]

On Wednesday 30 November 2011 09:26:16 Lindsay Mathieson wrote:
> On Tue, 29 Nov 2011 08:05:02 PM Milian Wolff wrote:
> > > Looking at the Akonadi mysql database I see that I have 3 large tables:
> > > - parttable:                  587230 rows;
> > > - pimitemflagrelation:                241688 rows;
> > > - pimitemtable:                       294840 rows;
> > 
> > I just want to comment on this and leave the rest to the real pimpsters:
> > 
> > You say here that this is an outrageous amount of data and that it has to
> > be  slow and what not. That is actually not true. This are just a couple
> > of
> > thousand rows, something that MySQL should handle just fine.
> 
> eh? the row count above varies from *two hundred thousand* to *five hundred
> thousand*

Again: So what? MySQL should handle it just fine.

bye
-- 
Milian Wolff
mail at milianw.de
http://milianw.de
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kde-pim/attachments/20111130/a5cc471a/attachment.sig>
-------------- next part --------------
_______________________________________________
KDE PIM mailing list kde-pim at kde.org
https://mail.kde.org/mailman/listinfo/kde-pim
KDE PIM home page at http://pim.kde.org/