General information
Title:
In-memory SQLITE as a replacement for VFP-cursor-based algos
Environment versions
Network:
Windows 2008 Server
Hi all,
I am starting the rewrite of a VFP-based application. The UI is still undecided but the glue language for the application is: that's python.
An essential key of the success of this rewrite: the ability to translate a decent part of the current application logic. Since the current VFP app makes a very significant use of VFP temp indexed cursors massaging data with a mix of both SQL and non-sql VFP operations, I definitely want to find a robust alternative to VFP cursors within the python eco-system.
On the paper, current SQLITE has everything that fits the bill to replace VFP cursor operations including a great "in-memory" mode, UDFs and a lot more. For those among you who have an experience in SQLITE, I'd be glad to get your feelings on their respective merits in terms of local temp storage.
I am especially interested by the performance level that I can expect with "in-memory" application-level data stores in view of rushmore-optimized VFP operations we are all used to and, as far as I am concerned, always amazed, even in 2015...
Regards to all of you
Daniel
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only