Page 1 of 1

Documental management

Posted: Fri 17 Sep 2010 21:25
by merovingio
HI!
I works at alternative Documental management for a big society (3000 users). I have problem to develop because when I update (adding recors) exist delay, the MySQL server not update quickly the table.
I use before TransStart after each append Commit.
Who help me?

P.S. I use C++builder 2009.

Posted: Wed 22 Sep 2010 10:14
by Dimon
If you change data (e.g., insert, update, delete), it is saved in a MySQL database automatically on calling the Post method, unless you use transactions.
Does the delay persist if you don't call StartTransaction and Commit? If not, don't use transactions for single SQL queries.