I'm building a multi-page app but i'm having an issue with the database:
On the first page I have a form that I am using to populate the database and navigate to the next page. On that page I have another form connected to the same database.
On the second page I select the first record in the list (the latest one that I just added). However when I run the query to retrieve database on page load the response I get is missing the latest record. However it does return it if I manually run it a few seconds after the page loads.
Even when looking at the database it there seems to be a delay before the record appears.
Is there a way to optimise the database updating speed?