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.

Reply via email to