I'm building a simple app that writes form records to a database and displays them on a webpage. I'm using webpy 0.36, Elixir-7.1, SQLAlchemy-6.4, MySQL 5.0.92.
The problem is that my app is reading a bogus number of records from the database. In fact, immediately after I create a new record, if I repeatedly reload my list of records page, the number of records displayed will hop around until finally the correct number of records is displayed. After about 30-60 seconds the correct number of records will be displayed on the page. This bug is repeatable. I've verified (via command line query and phpMyAdmin) that the correct number of records is stored in the database. MySQL query caching is disabled. The following line of code returns the wrong number of records for a short while after creating a new record: campaigns = Campaign.query.filter_by(webinar_id=id).order_by('campaigns.created_at desc').all() Any ideas? Thank you in advance for your help, Dale -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.