SQLite in MQL5: new features and performance testing - page 2
You are missing trading opportunities:
- Free trading apps
- Over 8,000 signals for copying
- Economic news for exploring financial markets
Registration
Log in
You agree to website policy and terms of use
If you do not have an account, please register
Is it difficult in principle to synchronise access to the same database from different programmes/terminals? Are we getting ersatz again?
Now you can use databases instead of files to store large amounts of data.
We don't have such a task in front of us at all.
Have you seen the performance table above? It's often faster in MQL5 than in C++.
Of course, everything is multi-threaded and everything is correct.
The question is about what happens if different programs/processes independently access the same database file. Not one program (MQL5) but several independent programs that do not know about each other and do not use the same database handle.
The performance, yes, is excellent.
Yes, different processes in Sqlite will probably be deadlocked.
Maybe database handle should be a preprocessor directive for each individual file, which should be declared in each EA/script,
something like internal common handle for base.
Stop spreading blatant nonsense about "killing SSDs" from incompetent users.
The Terminal-to-Terminal copiers in the Market are implemented on the principle of updating the data in the file every 10 seconds.
It's not hard to calculate how many records that is per year.
By the way... recently noticed that the laptop is slowing down. Cleaned the drive, decided to check how the ssd feels, as this shaitan hardware is not well studied for me. Checked it showed 68% remaining life, laptop is just over 2 years old. That's funny.
But as far as I remember, the screw on the spindle could have died after 2 years quietly.
System drive, all appdata/roaming files for MT5 are on another one, haven't checked that one
The Terminal-to-Terminal copiers in the Market are implemented on the principle of updating the data in the file once every 10 seconds.
It is not difficult to calculate how many records this is per year.
Thank you) valuable introduction.
Now you can use databases instead of files to store large amounts of data.
If you want to exchange data between terminals, what if you make it possible to connect one terminal for editing and the other only for reading, like files, all through super fast memory?
would it be possible in mql4?