Re: [Modeling-users] SQLite inserts slow

[Mario R. <ma...@ru...>]

>   While we're at it, are there other PRAGMAs that you all using
>   sqlite think they should be controlled in the same way?

I have not played with sqlite pragmas, so none that I can think of. 
But, this makes me think of another minor issue... given that the 
adaptorName is specified in the model, should there not be a place or 
hook to specify any adaptor/db-specific initialization sql/code?

Or, stated differently, should not adaptorName be specified in the 
config file, along with the connection dictionary? And, should not the 
config file contain or point to sql or other code to be executed on 
specific events, such as when db is created, when connection is 
established, etc. This flexibility, while it may risk being abused ;),  
could avoid getting stuck by the frameworks limitations at any given 
moment....

mario