Interlinking and Database Size
Posted: Sat Aug 18, 2018 7:02 am
Hi everyone. As a new user of EssentialPIM Pro I am wondering how large I can expect to go without sacrificing speed and efficiency. I selected this application because I was looking for a simple desktop solution minus all the "extras" you find with so many other CRMs these days. Yes, I know this is technically a PIM and not a CRM, but I have devised a simple interlinking approach between Contacts, Tasks, Notes and Emails that delivers the CRM functionality I need. I love being able to keep things focused and clean.
I can see my Contacts list growing quickly to 10,000+ records, while the Tasks, Notes and Emails will likely get up to 25,000 or 30,000+. I have read a number of comments on this forum about how large you can go with EPIM and I find them encouraging. I've also read elsewhere that Firebird typically has no trouble scaling into the multi-TB range, so that's good news as well.
I guess I am just looking for reassurances that interlinking via the GUI will scale well. I assume there is a table or view under the hood that tracks manually interlinked records, but what do I know? Is there any risk that this approach will affect latency as the database gets larger? I'd be interested to hear others' comments about how large they are getting with their databases and whether interlinking creates any problems at scale. Thank you.
I can see my Contacts list growing quickly to 10,000+ records, while the Tasks, Notes and Emails will likely get up to 25,000 or 30,000+. I have read a number of comments on this forum about how large you can go with EPIM and I find them encouraging. I've also read elsewhere that Firebird typically has no trouble scaling into the multi-TB range, so that's good news as well.
I guess I am just looking for reassurances that interlinking via the GUI will scale well. I assume there is a table or view under the hood that tracks manually interlinked records, but what do I know? Is there any risk that this approach will affect latency as the database gets larger? I'd be interested to hear others' comments about how large they are getting with their databases and whether interlinking creates any problems at scale. Thank you.