1

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?

5 replies

null
    • Mel_Charles
    • 1 yr ago
    • Reported - view

    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 ...

      • Alex_Mumm
      • 1 yr ago
      • Reported - view

      Mel Charles Thanks Mel. I tried downloading a backup and uploading again to create a copy, but it didn't make a noticeable difference. 

      I don't have any large images, but I do have a rich text field which I could replace with a multiline text field if it would make a difference.

      When you say you switch off most fields, you're talking about this checkbox?

      I have so far been leaving the three settings in the screenshot at default. I can turn off Global Search for most fields. Should I try anything with the Index and Binding settings?

      Is this the sort of thing that Ninox support would help me out with if I reached out to them?

    • Mel_Charles
    • 1 yr ago
    • Reported - view

    Hi Alex

    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 support@ninxo.com 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

      • Alex_Mumm
      • 1 yr ago
      • Reported - view

      Mel Charles I spoke to support and found a solution. I had too many select statements in the fields shown in the table view columns. They were referencing a data table with 60,000 rows (alcoholometry data for temperature/density corrections). I created a second table view with only the bare minimum columns showing so I can quickly switch between records. I kept the old table view for when I need to see more details. The new table loads instantly! Problem solved!

    • Fred
    • 1 yr ago
    • Reported - view

    Yes, it is always the select statement. There are ways to minimize those and still get calculations done. I have a sport league so stats are the basis of any sports, so there are lots of calculations. I've learned ways of minimizing selects.

Content aside

  • Status Answered
  • 1 Likes
  • 1 yr agoLast active
  • 5Replies
  • 291Views
  • 3 Following