Hello,
I am not really sure where to begin this post but I'm looking for a discussion/debate/direction on using SQLite in oracle MAF. I know that creating a database is easy. I know that writing/reading to the database is nothing out of the ordinary. However, using SQLite is fine and dandy if every is happening in one thread. With oracle MAF, if you have a single thread, then you are pretty much holding the UI hostage when you need to execute a process that takes some time. So Ideally, any process that takes time is moved to a background thread so that the UI can render and transition from one page to another smoothly. If only one thread is used, then transitioning from one feature to another, or one page to another will be slow as data is loaded.
Adding to this another background thread that needs to synchronize data to some server and we already have 2 threads that require read/write connections. This is of course a problem.
To me, it seems that the local SQLite database is a major bottleneck and I would like to get some direction and share some ideas about this topic.
Please share any ideas and experiences you have regarding this topic.
Regards,
Majdi Jaqaman