search

atk4 / data

Data Access PHP Framework for SQL & high-latency databases
https://atk4-data.readthedocs.io
MIT License
270 stars 46 forks source link

Improve SQLite LIKE performance #1209

Closed mvorisek closed 3 months ago

mvorisek commented 3 months ago

Based on https://sqlite.org/forum/info/00f60e440cb23c99 discussion.

The performance for 1M rows went from 8_000 ms to 250 ms.