Very slow opening table
I have a table with many many fields (about 55). The form associated with it performs okay, but opening the table itself takes almost a minute even though there are only 36 records so far. I'm using the web app.
What part of my database should I be looking at to try to fix this? Too many fields? Code issues?
Alex thanks interesting..
One of my table/forms has approx 100 fields and about 13,000 records in it and it opens almost instantly and I to use the online version.
I also have another db with over 900,000 records in it and this opens with about 1.5 mins (at this volume I would expect a small delay it getting to info from the remote server! but again I have not had to do anything to tweak the table/form
I cant think of any think obvious but I tend to switch off most fields that do not need to be searched on from a global search point of view
Does you table have any large stored image fields ?
It's possible you may have a link issue to the ninox server ( i have had this in the past) and I asked ninox to give the server a virtual kicking which cured it.
Just a thought .... as you are on the web version. Try saving a one off backup (manual) copy then export it to your desk top and then reimport it (you can give it a new name or let Ninox append "copy" to it and see if that version is cured... I have seen ninox recommend this is the past ...
Yes from my perspective I don't need every field to be found on a "global search" it seems a shame that Ninox sets this by default every time you create a field.
I would leave the per record by server as the default.
However. before you wade through every field. I would suggest you email firstname.lastname@example.org and maybe get them to do a screen share. Because you should not be getting a slow connection on that few records.. It should be pretty dam quick!
Tell them if it is slow opening the table just on the first occurrence when you open the database or every time you open it whilst connected..
Also do you have that table open by default when you log in and if you have any global script that run when you log in.
Another option is (that's if you are agreeable) upload a copy of your db here and and I would be happy to try and see how it opens on my connection (on on web version) so should be a good comparison for timing