Home > Net >  Can I use SQLite for heavy use purpose?
Can I use SQLite for heavy use purpose?

Time:09-22

Consider two application.

  1. "A" application receives data from internet like player position and other details
  2. "B" application which also needs the player position but it will be blocked from accessing internet. So the only way is to use SQLite sync player position (these frequently updates in milliseconds).

I can't even use socket or any other plugins too. So do you think SQLite can handle read and write in milliseconds without using CPU heavily ?

CodePudding user response:

If you wish to share the data in anything like real-time then I would use something like inter-process pipes or file mapping (memory) for this.

Writing data to and reading it back from any form of hardware storage will add quite a delay to the data passing, which will only become worse as the hardware data cache is filled. Hardware is okay for historic data.

Both are supported by Win32 and should be accessible even if you use .NET to produce a UWP application.

See here

  • Related