[WhiteDragon]

It will perform better than anything Graal has built into it if you have a lot of data. If you only have small amounts of data (which I think classifies 99% of Graal), avoiding the overhead of SQLite is probably faster.

But it any case, it's an extra layer of complexity. Sometimes that complexity is required, and if you find yourself implementing data structures in GS2 to help you lookup data faster, then you should probably starting using SQLite since it's already done for you.


It's also important to note here that it's really easy to suck at SQL (just like anything else) and make everything run slow as hell. You need to be careful with how you define your schema and queries, make sure to index properly (and sometimes even give up certain relational properties) in order to maximize speed. If you aren't careful you can definitely make stuff run slower than whatever you would do in GS2, probably.


So in summary, it's another tool, and imo it only needs to be used when you have particularly large amounts of data, and when you do, you need to go read about a bunch of stuff regarding relational databases and proper schema design.