My Blood Glucose Diary - problems

Thanks! ^_^

Hi, before I take all the glory I should point out that both Simon and I have been working on the problem and both probably contributed to the solution.

For the technically minded, a brief explanation. The website runs on top of a database, which is basically a place to store information. This was where the cause of the problem lay. The number of diary entries had reached such a level that reading them to display on the site was taking too long. This is partly because everyone's diary entries are stored together. The site knows who you are from your login and only reads your entries from the very long list. What we had to do was speed up the reading of the list. Simon changed the way it was read and I added things called indexes. Just like a book index, a database index helps you to find the information you want quicker. The two things together seem to have got things back to a reasonable speed. This stops the 'something went wrong' error because the web page gets the diary entries back quick enough and doesn't timeout presuming the entries are not coming.

It took a while to fix because it wasn't obvious initially what the problem was and then we needed to test any changes before making them live just in case.
thank you everyone for your patience.

Thanks to you both.
Regards
Garry