garamantex
New Member
HI, i have a list whit 400 records and the load time is very high, about 40 sec. I try resolve this issue creating INDEX for the tables but this dont work. What can i do?
-
New Commercial Services Section
We have now opened a commercial services section here on the forum for registered users. If you have a Fabrik project that you wish to have someone work on for you, post it under Help Wanted. If you are an application developer and wish to earn some money helping others, post your details under Fabrik Application Developers.
Both of these are unmoderated. It will be up to both parties to work out the details and come to an agreement.
-
Joomla 5.1
For running J!5.1 you must https://fabrikar.com/forums/index.php?wiki/update-from-github/ or include the new file manually https://fabrikar.com/forums/index.php?threads/joomla-5-1-and-fabrik-cannot-find-files-error.54473/post-285151 See also Announcements
List load time is very slow
- Thread starter garamantex
- Start date
cheesegrits
Support Gopher
And how many rows are you displaying.
As Troester indicates, the usual reason for excessive load times are join / CDD elements incorrectly configured (aren't using unique keys), although sometimes it's simply that you have "display rows" set to 0 (all rows), or are likewise simply trying to show too many rows, with too many elements per row. My rule of thumb is that 500 displayed elements is about the most you should use (so 50 rows of 10 displayed elements, or 10 rows of 50 elements).
-- hugh
As Troester indicates, the usual reason for excessive load times are join / CDD elements incorrectly configured (aren't using unique keys), although sometimes it's simply that you have "display rows" set to 0 (all rows), or are likewise simply trying to show too many rows, with too many elements per row. My rule of thumb is that 500 displayed elements is about the most you should use (so 50 rows of 10 displayed elements, or 10 rows of 50 elements).
-- hugh
garamantex
New Member
Hi, i have 25 elements, 1 of them is a repeat field, in list view i have 7 rows, i have no calc fields and have 3 simple dropdowns
i dont understand the index thing, from the database select the ID fields and assign them an index, it's all I've done so far.
i dont understand the index thing, from the database select the ID fields and assign them an index, it's all I've done so far.
cheesegrits
Support Gopher
Well, something is horribly wrong then. That should display almost instantly.
I'd have to look at a Joomla debug profile to get an idea of the issue. Is this site live, or can you enable J! debug and point me at the list?
-- hugh
I'd have to look at a Joomla debug profile to get an idea of the issue. Is this site live, or can you enable J! debug and point me at the list?
-- hugh