Documental management

merovingio · Post by **merovingio** » Fri 17 Sep 2010 21:25

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.

Dimon · Post by **Dimon** » Wed 22 Sep 2010 10:14

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.