Performance issue - flatfile or sqlite - any pros here?

Hi, I am working on our animation engine and now we are reading all the data from a sqlite db. It lags sometimes when we are dealing with more then 3K of entries.

I was wondering if it faster to read it in as a lua table directly from a flat file. If so, is it possible to dynamically load a certain file at at certain moment?

Best regards, Joakim

[import]uid: 81188 topic_id: 23632 reply_id: 323632[/import]