Re: [sqlite] Repost: Accessing a DB while copying it causes Windows to eat virtual memory

he manager. If a process opens a file using FILE_FLAG_RANDOM_ACCESS, then it (or any other concurrent process) that happens to access sequentially can grind the system to a halt. Sounds like a nightmare for any install running an AVS or backup. Thanks for your help! -Stan On Wed, Jul 8, 2009 at 5:15

Re: [sqlite] Repost: Accessing a DB while copying it causes Windows to eat virtual memory

that simply copying the file would result in the same amount of memory being used, but it doesn't. I'm going to head to a Windows forum to try to find out more about what's happening, but the list users may want to be aware of this if they plan on using large sqlite DBs with Windows 2008. Thanks, -Stan

Re: [sqlite] Repost: Accessing a DB while copying it causes Windows to eat virtual memory

e, AllocationSize: 0, Impersonating: TESTBED9\Administrator" "6:30:41.2837648 PM","sqlite3.exe","1988","IRP_MJ_CREATE","C:\inetpub\wwwroot\Vivisimo\bin\fake-cache.sqlt","SUCCESS","Desired Access: Generic Read, Disposition: OpenIf,

Re: [sqlite] Repost: Accessing a DB while copying it causes Windows to eat virtual memory

t; exclusive transaction. > > Stan Bielski wrote: >> Sorry for the repost, but the original thread was hijacked by another >> list user. This is a serious problem IMHO; it looks like the DB can't >> be backed-up without rendering the machine unusable if a query hits it >>

[sqlite] Repost: Accessing a DB while copying it causes Windows to eat virtual memory

(seemingly identical) to the amount of data copied since the process opened the file. Is there a workaround for this issue? Any assistance or info is appreciated. Thanks, -Stan ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080

[sqlite] Accessing a DB while copying it causes Windows to eat virtual memory

the rest of the copy the OS will consume virtual memory linear (seemingly identical) to the amount of data copied since the process opened the file. Is there a workaround for this issue? Any assistance or info is appreciated. Thanks, -Stan ___ sqlite-users

[sqlite] Reducing memory usage when reading a blob

the blob is bigger than memory... Thanks, -Stan

Re: [sqlite] Performance problems potentially related to index scalability

On 2/8/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: "Stan Bielski" <[EMAIL PROTECTED]> wrote: > > Anyone care to take a guess what's going on here? The problem is that you are thrashing. The working set on the database file is exceeding the amount of memor

Re: [sqlite] Performance problems potentially related to index scalability

index, the total performance should be better. If I wait until after the inserts, the index will take less than a minute to build. Unfortunately, that's not an option for this application :-( -Stan

[sqlite] Performance problems potentially related to index scalability

's storing the index? It seems to me that something is doing random I/O, and I was hoping that if I could "force" the index's pages to stay in the cache, then I'd be able to avoid that. Any help is appreciated, -Stan

Re: [sqlite] User function in WHERE clause

O.K. This is what I need. Thanks -- View this message in context: http://www.nabble.com/User-function-in-WHERE-clause-tf2009603.html#a5543377 Sent from the SQLite forum at Nabble.com.

Re: [sqlite] User function in WHERE clause

parameters in xFunc? E.g. what is it "sqlite3_context"? Thanks for your time. Stan -- View this message in context: http://www.nabble.com/User-function-in-WHERE-clause-tf2009603.html#a5542532 Sent from the SQLite forum at Nabble.com.

[sqlite] WHERE with user function

problem? Thanks Stan -- View this message in context: http://www.nabble.com/WHERE-with-user-function-tf2015394.html#a5539399 Sent from the SQLite forum at Nabble.com.

Re: [sqlite] User function in WHERE clause

, IntValue) ? And how to include MYFUNC to SQLite ? ... you see - troubles of a beginner :-). Thanks Stan -- View this message in context: http://www.nabble.com/User-function-in-WHERE-clause-tf2009603.html#a5535131 Sent from the SQLite forum at Nabble.com.

[sqlite] User function in WHERE clause

Hi, is there a way to create user function similar to LIKE? I'd like to use my function in clause WHERE. E.g. this selection: SELECT * FROM Table WHERE Name MYFUNCTION param Param is integer. Thanks Stan -- View this message in context: http://www.nabble.com/User-function-in-WHERE-clause