Your problem is not with SQLite. It is with Delphi, or with some anti-virus or backup program running on your computer. To investigate, download the SQLite shell tool and install it on the same computer. Use the shell tool to open that same database and execute the command <code>SELECT Name,Cat FROM MyTable;</code> (replace '<code>MyTable</code>' with whatever the table is called). Does that operation also take 5 or 6 seconds ? If it's faster add the <code>LData</code> column in too and check the time for that.