Maximum SQL performance

[CBonnkirch]

Hi together,

we are running a small server application on both mobile and desktop. This app accesses a DB with up to 5000 records and corresponds via UDP.

Now we have a request to recommend a desktop to use this app with more than 70000 records. So, my question is how to get the max. speed from SQLlite:

- Does SQLite use multiple cores?
- Can i force SQLite to use (more) RAM?
- Is a faster CPU (more clock frequency) any helpful?

Thanks in advance
Christof

 

[Erel]

SQLite is not a server. It runs in your process.
70k records is not considered a large database.
Make sure that you are running efficient queries (and have the right indexes) and it should work fine.