[Vtigercrm-developers] Weird requirement

[Rubén A. Estrada Orozco]

Tony, be careful with related records. When you go to the detail view of
say an account that has many (thousends?) related records, the loading time
can become unbearable. I guess you could improve that part of the code
to decrease loading time.

Alan, just out of curiosity, what kind of infrastructure do you use for
such a big database?


Saludos

Rubén


On Fri, Jul 31, 2020 at 2:57 AM Alan Lord <alanslists at gmail.com> wrote:

> Not sure what the issue is really?
>
> I've got a few customers where tables like crmentity contain tens of
> millions of rows.
>
> I don't think it will be a problem. Just make sure you have indexes on
> the relevant columns for querying.
>
> HTH
>
> Al
>
> On 31/07/2020 08:45, Tony Sandman wrote:
> > Customer, planning to store hundreds of thousands of related records to
> > one parent (all custom)
> > so lets say 10.000 parent records will translate to millions of related
> > records.
> > Been asked if can it be that we will store each set of related records
> > to a different table.
> > Is it something out of space?
> >
> > T
> >
> > _______________________________________________
> > http://www.vtiger.com/
> >
> _______________________________________________
> http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20200731/e43bdd8c/attachment.html>