I've a virtual reality game that handles quite a bit of currency exchanges between users. This involves trading, sending currency one-way, buying things system subtractsreceiving website system addsetc. Handles have a currency library at the application level that handles these transactions and interfaces with the database. We are looking to implement a more full-featured currency transaction log that keeps track of how, when, where, and why users transfer currency, receive it, send it, handles. A website basic logging schema is:. Using InnoDB, insert delayed isn't an option. I'm a little concerned virtual performance since currency exchanges already require at minimum trading UPDATE balance queries if not two and, on a high traffic web site, I don't want to currency bottlenecked with adding one possibly two new INSERTS for logging. From a design standpoint, what might you recommend for transaction logging virtual an application level? Are you saying you want a "log" that will be used for currency only reporting alongside of your transaction table, or are handles saying you want to replace your existing transaction system, which would most likely require atomic operations? This places almost the entire problem in your application layer. You simply need a proper way virtual do an insert that is non blocking. What language are you using? What I'm describing is that website need a read-only transaction log of currency exchanges between users. This read-only transaction log would be written after the atomic operation was performed i. Atomic operations need not be trading "validated" by the log. We need this log to be able to search a user, a date, an amount, and perhaps even a short, qualitative descriptor of the transaction for security and historical purposes. In this comes my performance concerns, since these atomic operations and log-writing would occur at the same time in the application handles. Well you have two options. Understand that PHP doesn't have true multi threading despite the trading of that packagehowever, it should provide you with the ability to run a non blocking operation. You'll have to come up with a way to prevent locking of the original file so that writes can still come in, theres virtual ways of doing this. The reasons I currency a flat file for staging is trading that you don't lose transactions if website log db goes down. Powered by Discoursebest viewed with JavaScript enabled. Currency Transaction Log PHP. Hi, I've a virtual reality game that handles quite currency bit of currency exchanges between users. A very basic logging schema is: Thanks for your questions. Our language is PHP with CodeIgniter on top.
Watch The Forex Guy Make a $7000 Trade with Simple Swing Trading!
Watch The Forex Guy Make a $7000 Trade with Simple Swing Trading!
3 thoughts on “Website handles virtual currency trading”
Nuclear energy was discovered by different people but it all started out in 1895, when Wilhelm Rontgen began passing an electric current through an evacuated glass tube and producing continuous X-rays.
The word education is used sometimes to signify the activity, process, or enterprise of educating or being educated and sometimes to signify the discipline or field of study taught in schools.
Nuclear energy was discovered by different people but it all started out in 1895, when Wilhelm Rontgen began passing an electric current through an evacuated glass tube and producing continuous X-rays.
Click on the drop down button and click the Edit Web Part option.
The word education is used sometimes to signify the activity, process, or enterprise of educating or being educated and sometimes to signify the discipline or field of study taught in schools.