Two Questions for experienced users
I am working on an extension of an existing database.
Before start working this out, I have two general questions;
1. Influence of number of related tables on database speed?
2. Influence of number of indexes on database speed.
Does the number of related tables effect the speed of the database? e.g. I use the Advanced Value Selection of PhilModJunk for Radio Buttons and CheckBoxes, just because they offer more possibilities and they look better. But this means I need extra related tabels with X relation. With the extension I will end up on my main table with 12 related tables.
(And using the Advanced Value Selections also means more portals, sometimes within a popover).
I know using an index on a certain field speeds up searching and relations. But I also know that every change on an indexed field, means the index has to be updated. So, many indexes can slow down the entire database.
I can’t find proper documentation when using an index and when not. (And when Full Indexed or minimal).
(Using FMPA version 13.05)
Thanks in advance,