This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Anyone else experience a slow read in speed with SQLITE tables? I remember this used to happen with Excel a lot before the driver modifications. Wondering if it's just me. The table isn't too terribly large.
Are you reading from a local drive? Are you using a Mac? - These would be my first troubleshooting questions. I've not recently written/read from SQLite tables, but wondered about the 2 questions when I read your post.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.
Not sure what driver Alteryx is using to access SQLite3 DBs but it is very slow. I also have issue with the fact that an SQLite input does not have the option to Cache results like other databases. This along with the slow driver makes using SQLite in Alteryx very painful.
It's sad because, using the official command line utility, SQLite runs circles around Alteryx speed-wise if indexes are properly set up and the DB is in-memory.