In-memory SQLITE as a replacement for VFP-cursor-based a

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

In-memory SQLITE as a replacement for VFP-cursor-based a

Message

From

02/02/2015 09:52:33

Doug Hennig
Winnipeg, Manitoba, Canada

30/01/2015 19:11:38

Rick Strahl
West Wind Technologies
Maui, Hawaii, United States

General information

Forum:

Visual FoxPro

Category:

Other

Title:

Re: In-memory SQLITE as a replacement for VFP-cursor-based a

Environment versions

Visual FoxPro:

VFP 9 SP2

OS:

Windows Server 2012

Network:

Windows 2008 Server

Database:

MS SQL Server

Application:

Web

Miscellaneous

Thread ID:

01614634

Message ID:

01614745

Views:

Hi Rick.

>SqLite is very dependent on proper configuration to get good performance out of it. Default config is pretty slow... but with turning off the transaction log (journal) and in memory usage it can do OK.

Do you have an example of the configuration changes you make?

Doug

Map

View

Click here to load this message in the networking platform