SQLLite application still running slow

Question

I made a pos for a pizza company. It uses 3-4 computer accessing a sqlite database in a network folder. The problem is, they slow down terribly when business volume goes up. My thought was that the read/write operations are occuring more frequently than I had anticipated. Would splitting the database up into seperate files instead of one large file make a difference?

Ady · Answer

Well i say that you always should split any program you make in small parts. Try splitting...hope that works. Although maybe the network speed is slow or it has a little latency (don`t know about that pizza company so please don`t judge me :D). Thanks

Ady · Answer

Good thinking! Always separate your functions and operations as much as possible. And don`t forget to use comments if possible... for later edit. Thanks for the accept. If you`ll have anything to ask... i`m here to help! :D

patrick · Answer

Splitting it seemed to work. Also I moved printing operations on their own thread.