3 ms·
https://areweguiyet.com/ https://areweguiyet.com/ Also did you test similar functionality in C++, I haven’t compared many implementations but I app I use that
by jpc0 1y ago
https://areweguiyet.com/ https://areweguiyet.com/
Also did you test similar functionality in C++, I haven’t compared many implementations but I app I use that has an SQlite db being read with Qt(C++) is pretty sluggish whenever you touch the DB.
Maybe store the values in a dict and only read/write from sqlite when needed. Dicts are very fast in python.
- dotancohen 1y agoYes, that's what I'm doing. It's the initial load that is heavy. I've also tried implementing lazy loading and pagination, with a pseudo-infinite scroll technique based on SQL LIMIT pagination, but the resulting CPU and memory spikes are noticeable.
- prmoustache 1y agoThis website is useless if accessibility compatibility is not mentionned.