yard.com> wrote:
> On May 26, 2017, at 5:46 PM, Jamie <eqrecov...@yahoo.com> wrote:
>
> Without going into too much detail of explaining C#, everything is discarded
> appropriately. All disposable objects are wrapped by using statements. And
> byte arrays vanish once
. Have you verified that what you're reading in is being
disposed after use and not just sticking around?
Have you tried the same queries on the SQLite3 client to see if you get the
same blow up of memory?
On Fri, May 26, 2017 at 5:00 PM, Jamie <eqrecov...@yahoo.com> wrote:
> > So, y
as Out of Memory errors), or are you just upset
that the RAM for which money was paid is actually being used for something?
--
˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı
> -Original Message-
> From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org]
> On Behal
hy I think the
problem is related to sqlite and reading byte data (BLOBs).
On Friday, May 26, 2017 1:04 PM, Keith Medcalf <kmedc...@dessus.com> wrote:
On Friday, 26 May, 2017 08:27, Jamie <eqrecov...@yahoo.com> said:
>> <https://msdn.microsoft.com/en-us/libra
mens Ladisch <clem...@ladisch.de> wrote:
Jamie wrote:
> this is not the normal Windows File Caching that you would typically
> see. File Caching would be under STANDBY Mapped File
To rule out SQLite's mmap, execute "PRAGMA mmap_size = 0", and then
confirm with th
ing the command "PRAGMA mmap_size=0;" on the connection?
>
> https://www.sqlite.org/pragma.html#pragma_mmap_size
>
> --
> Joe Mistachkin @ https://urn.to/r/mistachkin
On Friday, May 26, 2017 4:43 AM, Clemens Ladisch <clem...@ladisch.de> wrote:
Jamie wrote
y, May 25, 2017 8:02 PM, Keith Medcalf <kmedc...@dessus.com>
wrote:
On Wednesday, 24 May, 2017 18:48, Jamie <eqrecov...@yahoo.com> wrote:
> When I'm performing a large amount of selects of GLOBs/thumbnails from an
> ongoing SQLiteConnection, I'm having a problem where t
I tried changing it to several different values for that pragma, but it did not
seem to have any affect on how large the Active Mapped File could grow. The
pragma was set before anything else was done on the connection. Although
futile; I also tried attempting to use the pragma on the
When I'm performing a large amount of selects of GLOBs/thumbnails from an
ongoing SQLiteConnection, I'm having a problem where the Windows Active Mapped
File will constantly grow out of control in size (memory leak?). This is under
Windows 7, using a .Net Framework 4.0 C# application with
I'm putting together a quick proof-of-concept application to explore the use of
System.Data.SQLite for applications running on Windows Mobile 6.1 using .NET
Compact Framework 3.5.
As long as I put the data access logic in the application, and make sure that
System.Data.SqLite.dll and
better generic approaches, or other tricks
I've missed?
(At the moment I have a query that does not use EXCEPT but is instead
tied to the particulars of my schema/data, which is fine. I'm just
curious about the more general case.)
Jamie
___
sqlite-users
ct, at least.
> The whole thing might work faster if you first load a representative
> dataset into all tables, then run the ANALYZE command.
As part of the database creation step of the program that uses the
database, I run ANALYZE after adding the data and indices.
Jamie
On Sat, 2012-10-27 at 02:26 +0700, Dan Kennedy wrote:
> Thanks for reporting this. Now fixed here:
>
>http://www.sqlite.org/src/info/e24ba5bee4
Excellent - thank you for the speedy fix!
Jamie
___
sqlite-users mailing list
sqlite-users@s
bug
report, or is this a known issue, or have I missed a trick somewhere?
Jamie
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
t this request before.
Thanks,
Jamie
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
key, but are solely the column name. Is this expected?
Thanks.
Jamie
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
r without issue. Any insight appreciated.
TIA,
Jamie
The information contained in this message may be confidential and legally
protected under applicable law. The message is intended solely for the
addressee(s). If you are not the intended recipient, you are h
reading and returning without closing them. I fixed this and all is well now.
Jamie
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
en(path) , SQLITE_STATIC);
/* I've tried every variation for argument 5 here */
retVal = sqlite3_step(statement);
retVal = sqlite3_reset(statement);
}
sqlite3_finalize(_upsertStatement);
sqlite3_close(_database);
/* end EXAMPLE.c */
------
Jamie Hardt
http://www.imdb.
makes a difference.
- Jamie.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I am using the C/C++ interface to SQLite version 3.6.17 in a Linux
environment.
I am using SQLite as part of a CGI program on a clustered group of
webservers which do searches on the database. Some of these searches
can happen at the same time as multiple instances of the CGI program can
execute
21 matches
Mail list logo