AnsweredAssumed Answered

Database speed

Question asked by lijnbach on Dec 21, 2014
Latest reply on Dec 24, 2014 by lijnbach

Title

Database speed

Post

Hello everybody,

Are there general recommendations to speed up a database? I have a database with about 300 records and 600 related records. (Which is not much). Even in "List View", with just a few fields, the database is rather slow. I know that unstored calculated fields slows everything down. So, I limited the unstored calculated fields. (4 in total). I almost never use "Refresh window" because this also slows down the database when cycling threw records. All tables have a unique ID, full indexed.

Thanks in advance.

Hans Lijnbach.

Outcomes