Hello sqlite users, Hello dr. Hipp, I'm trying to speed up sqlite and I would like to change the default_temp_store so that all temporary tables are created in memory, instead of file.
I was wondering how can I do that. I've tried changing the TEMP_STORE macro to 3 - Always use memory, with no success: when doing PRAGMA default_temp_store, I always get 0. I would also like to know if there are any other things involved with changing this? Is the data integrity affected in any way? ( This might sound like a silly question, but I have to ask it ) Best regards, George Ionescu
