Sign in to follow this  
Followers 0
chkang

MYSQL data editing in real time(Without server restarting)

2 posts in this topic

I just made a simple MFC application for a MYSQL data editting. Because I want to use a another path finding algorithm for a AI intelligent.

So, In my MFC application, It accepts AI's current position and its environment objects data pose. With this information I can map the ingame's map information. As a result, I can adopt a path finding algorithm based on a information. However, When I update a new way-point pose in the MYSQL table(AI will get this way-point pose and will  move there).However  My server can't update in real time.

I mean, Whenever I edit mysql database, It will apply after server restart.

I want to update MYSQL database in realtime after editting by other application

What can I do?

Sorry for my bad grammer.
 

Share this post


Link to post
Share on other sites

Posted (edited)

Erm, sounds like the UDI's you are using are not committed to the database. So check your code if you either use auto commit
 

		/* turn on the autocommit */
		con -> setAutoCommit(1);

or if you are commiting after each UDI

mysql_commit()

[Edit] Oops, missed that the changes are present after a restart. That sounds REALLY strange. Committed UDI's, no matter if they are already flushed to disk or not, should be present after a commit. Suggest to ask at stackoverflow.com. There are a lot of mysql experts / C(++) developers.
 

Edited by Blacksheep

Share this post


Link to post
Share on other sites
Advertisement

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.