Gamestudio Links
Zorro Links
Newest Posts
Change chart colours
by 7th_zorro. 05/11/24 09:25
Data from CSV not parsed correctly
by dr_panther. 05/06/24 18:50
AUM Magazine
Latest Screens
The Bible Game
A psychological thriller game
SHADOW (2014)
DEAD TASTE
Who's Online Now
2 registered members (AndrewAMD, Nymphodora), 1,470 guests, and 5 spiders.
Key: Admin, Global Mod, Mod
Newest Members
firatv, wandaluciaia, Mega_Rod, EternallyCurious, howardR
19050 Registered Users
Previous Thread
Next Thread
Print Thread
Rate Thread
Page 2 of 2 1 2
Re: MySQL Gurus needed!!!! [Re: fastlane69] #213589
06/29/08 09:04
06/29/08 09:04
Joined: Oct 2004
Posts: 290
Latvia
Leonardo Offline OP
Member
Leonardo  Offline OP
Member

Joined: Oct 2004
Posts: 290
Latvia
Really? Well, that's nice! I'm just not used to the thought of leaving something to chance wink

By the way, I found this article:

MySQL C API Multiple Statement Execution

As I understand, if it executes more than one query at the same time, it produces many different result sets and you have to go through them, but this kind of function is not included in this DLL frown Well, I guess I just have to go with it and hope there will be no multiple queries. smile

Last edited by Leonardo; 06/29/08 09:05.

"Things of the mind left untested by the senses are useless."
Re: MySQL Gurus needed!!!! [Re: Leonardo] #213598
06/29/08 11:35
06/29/08 11:35
Joined: Mar 2003
Posts: 5,377
USofA
fastlane69 Offline
Senior Expert
fastlane69  Offline
Senior Expert

Joined: Mar 2003
Posts: 5,377
USofA
Quote:
I'm just not used to the thought of leaving something to chance


I don't see it as an issue of chance rather as an issue of timing.

Consider that in a poker game, people will change the world state on the order of seconds and minutes and not milliseconds. The world state in your game example means changing a card, folding, bluffing, ante-ing, hitting, etc... none of these actions are very fast in terms of the SQL database application and thus there is very little to no chance of concurrent queries being inconsistent.

Hence, In My Humble (and admittedly ignorant) opinion, while you may feel that this is leaving things to chance, in actuality even 100 function calls to a MySQL engine in a second (representing 100 functions, representing 100 tables) is child's play compared to what MySQL can do.

Re: MySQL Gurus needed!!!! [Re: fastlane69] #213600
06/29/08 11:39
06/29/08 11:39
Joined: Oct 2004
Posts: 290
Latvia
Leonardo Offline OP
Member
Leonardo  Offline OP
Member

Joined: Oct 2004
Posts: 290
Latvia
At least I got that off my chest smile Right now, I'm copying the results of the query into separate local strings immediately after it's execution. With the addition of this, I hope it will really be impossible for my worries to become true. laugh


"Things of the mind left untested by the senses are useless."
Re: MySQL Gurus needed!!!! [Re: Leonardo] #213605
06/29/08 11:54
06/29/08 11:54
Joined: Mar 2003
Posts: 5,377
USofA
fastlane69 Offline
Senior Expert
fastlane69  Offline
Senior Expert

Joined: Mar 2003
Posts: 5,377
USofA
Quote:
Right now, I'm copying the results of the query into separate local strings immediately after it's execution.


It sounds like you are creating a "queue" system for you mysql queries. If so, this is a good thing since while I believe that the timing nature of your game makes it so you don't have to worry about inconsistent queries, a queue system makes your game all the much safer!

Page 2 of 2 1 2

Moderated by  HeelX, Spirit 

Gamestudio download | chip programmers | Zorro platform | shop | Data Protection Policy

oP group Germany GmbH | Birkenstr. 25-27 | 63549 Ronneburg / Germany | info (at) opgroup.de

Powered by UBB.threads™ PHP Forum Software 7.7.1