[EMAIL PROTECTED] wrote:
"Trevor Talbot" <[EMAIL PROTECTED]> wrote:
Beyond that, I'm not aware of anything that would help.
All good advice. But you left off the obvious: Get a
faster disk drive. ;-)
...which does not really help unless you buy a very expensive
flash disk drive. How much
Hello drh,
Thursday, November 8, 2007, 3:03:07 PM, you wrote:
dhc> PokerAce <[EMAIL PROTECTED]> wrote:
>> I am using Windows Task Manager to determine memory usage. I minimize my
>> application (which causes the task manager to show a more accurate
>> measurement of memory used) and still the me
Hello Trevor,
Thursday, November 8, 2007, 5:48:59 PM, you wrote:
TT> On 11/8/07, PokerAce <[EMAIL PROTECTED]> wrote:
>> I am using Windows Task Manager to determine memory usage. I minimize my
>> application (which causes the task manager to show a more accurate
>> measurement of memory used) a
On Nov 8, 2007 5:04 PM, PokerAce <[EMAIL PROTECTED]> wrote:
> I am using Windows Task Manager to determine memory usage. I minimize my
> application (which causes the task manager to show a more accurate
> measurement of memory used) and still the memory usage is enormous.
Windows Task Manager do
On 11/8/07, PokerAce <[EMAIL PROTECTED]> wrote:
> I am using Windows Task Manager to determine memory usage. I minimize my
> application (which causes the task manager to show a more accurate
> measurement of memory used) and still the memory usage is enormous.
Task Manager is lousy at getting t
The documentation page is too scattered, and needs to be categorized:
short bits, like the intro and features lists; reference material,
like the SQL syntax and API pages; and detailed discussion, like the
locking methods and the like.
I echo P Kishor's comment that the date/time functions need to
I think the documentation section needs to be organized. I count over
two dozen links in a simple list with no apparent organization. Some
(like "copyright") might be best under some other heading, like
downloading. Some are minor topics, or of transient interest, such as
moving from 3.4 to 3.5.
[EMAIL PROTECTED] wrote:
We are looking at renovating the design of the SQLite
website and would love to have suggestions from the
community. If you have any ideas on how to improve
the SQLite website, please constribute either to the
mailing list or directly to me.
o The 'contrib' section cou
PokerAce <[EMAIL PROTECTED]> wrote:
> I am using Windows Task Manager to determine memory usage. I minimize my
> application (which causes the task manager to show a more accurate
> measurement of memory used) and still the memory usage is enormous.
>
>
Recompile version 3.5.2 with -DSQLITE_MEM
I'm sure I can use some #defines to point to my own malloc, realloc, and
free routines. Unfortunately, it may be some time before I get to this
so I'll have to stick with 3.5.1 for now.
Before I do that, I'm going to have to study the later source to try to
get a better understanding of what
I've noticed the 'Suggests for improving the SQLite website' e-mail and
point number (4) that drh made was the frequent releases of the sqlite
library make the library look bad.
I'm quite happy at the release rate and believe as one of the respondents
to the thread mentioned that 'release early, r
Mark Spiegel <[EMAIL PROTECTED]> wrote:
> I just started looking at 3.5.2 and notice that support for
> SQLITE_OMIT_MEMORY_ALLOCATION was removed. This is a problem for me.
> Is there some reasoning behind this?
Yes. We are doing a lot of experimental work on the
memory allocation. See
h
IMO, the http://www.postgresql.org/ site is the most appealing site of
the competing products. I would be happy if SQLite followed a similar
look.
I would try to keep the top-right menu links from SQLite.org, but I like
someone's earlier suggestion that they be grouped in categories. I'm
also fo
Hi Richard,
I might be in a minority on this list for suggesting that the SQLite
website could indeed become more helpful and informative through a
redesign.
I am not suggesting that the redesign necessarily be focused on
attractiveness, although, there can be some correlation in ease of use
and
I just started looking at 3.5.2 and notice that support for
SQLITE_OMIT_MEMORY_ALLOCATION was removed. This is a problem for me.
Is there some reasoning behind this?
I'm new to this list and to the SQLite website, so my feedback is more of
the "first impression" kind. And that impression is: the site is ok. It is
clear, simple, with almost anything I need reachable through one or two
clicks. The things I would probably do is place a google search field
somewher
What could be interesting is a listing of all the ways SQLite is used and
for users to upload their
details with a number of fixed fields like:
short description, size of database, number of users,
commercial/non-commercial, platform/OS, programming language, wrapper,
satisfaction with the applicat
Actually, I am. I abstract the database communication in my application,
but I access each database using their native API.
On Nov 8, 2007 12:44 PM, Joe Wilson <[EMAIL PROTECTED]> wrote:
> --- PokerAce <[EMAIL PROTECTED]> wrote:
> > "Are you certain it's sqlite RAM, and not your application?"
>
Rich Shepard wrote:
On Thu, 8 Nov 2007, Stephan Beal wrote:
google code award implies that it's free (doesn't it?)
Only to people not used to open source. "Release early, release often."
Definitely not. Its simplicity is its main beauty.
Stephan,
Good comments from your point of v
--- PokerAce <[EMAIL PROTECTED]> wrote:
> "Are you certain it's sqlite RAM, and not your application?"
>
> Yes, we are also testing PostgreSQL and MySQL and the application memory
> with those stays < 20 mb.
You're not using the sqlite3 API directly, are you?
If that's the case, I think your data
QFT
I agree with both Stephan *and* Rich. It would be great if the site
stayed clean, white, and straightforward. I don't personally have
difficulty selling SQLite to my boss because we've used it in many
successful projects, but I can see how the current site may not measure
up to so-called 'we
I love the website. Suggested improvements:
- link to the users site from home:
http://www.mail-archive.com/sqlite-users@sqlite.org/info.html
- a publicity page that contains links to interviews, reviews, etc.
- expand the list of things that cannot be done with virtual tables (it
lists triggers b
On Thu, 8 Nov 2007, Stephan Beal wrote:
google code award implies that it's free (doesn't it?)
Only to people not used to open source. "Release early, release often."
Definitely not. Its simplicity is its main beauty.
Stephan,
Good comments from your point of view. However, what the d
"Are you certain it's sqlite RAM, and not your application?"
Yes, we are also testing PostgreSQL and MySQL and the application memory
with those stays < 20 mb.
"Is your temp_store set to memory or file?"
I have not changed this, so it's whatever the default is.
"How are you performing your inse
[EMAIL PROTECTED] schrieb:
We are looking at renovating the design of the SQLite
website and would love to have suggestions from the
community. If you have any ideas on how to improve
the SQLite website, please constribute either to the
mailing list or directly to me.
Among the comments receive
--- [EMAIL PROTECTED] wrote:
> We are looking at renovating the design of the SQLite
> website and would love to have suggestions from the
> community. If you have any ideas on how to improve
> the SQLite website, please constribute either to the
> mailing list or directly to me.
Prize giveaway t
I am using Windows Task Manager to determine memory usage. I minimize my
application (which causes the task manager to show a more accurate
measurement of memory used) and still the memory usage is enormous.
On Nov 8, 2007 11:55 AM, Roger Binns <[EMAIL PROTECTED]> wrote:
> -BEGIN PGP SIGNED
If you have to set that manually, it was not set. I am using version 3.5.2.
I am doing tens of thousands of transactions, each without ~30 separate
INSERTs.
On Nov 8, 2007 11:40 AM, <[EMAIL PROTECTED]> wrote:
> PokerAce <[EMAIL PROTECTED]> wrote:
> > I'm trying to see if SQLite is suitable for
--- PokerAce <[EMAIL PROTECTED]> wrote:
> I'm trying to see if SQLite is suitable for large databases ( > 1 gb,
> millions of rows in each of several tables). Initially, the memory usage
> was outrageous (~ 500 mb for a 1.3 gb db), but I got that down to < 30 mb by
> setting the cache size to 0 an
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
PokerAce wrote:
> Initially, the memory usage
> was outrageous (~ 500 mb for a 1.3 gb db),
How are you measuring memory usage? You have to be very careful as most
operating system tools will report a number greater than the size of all
current malloc
PokerAce <[EMAIL PROTECTED]> wrote:
> I'm trying to see if SQLite is suitable for large databases ( > 1 gb,
> millions of rows in each of several tables). Initially, the memory usage
> was outrageous (~ 500 mb for a 1.3 gb db), but I got that down to < 30 mb by
> setting the cache size to 0 and se
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
> If you have any ideas on how to improve
> the SQLite website, please constribute either to the
> mailing list or directly to me.
"Search" is missing on the main page. I always have to click around a
bit until a page with se
On Nov 8, 2007 5:29 PM, <[EMAIL PROTECTED]> wrote:
> We are looking at renovating the design of the SQLite
> website and would love to have suggestions from the
> community. If you have any ideas on how to improve
> the SQLite website, please constribute either to the
> mailing list or directly t
I'm trying to see if SQLite is suitable for large databases ( > 1 gb,
millions of rows in each of several tables). Initially, the memory usage
was outrageous (~ 500 mb for a 1.3 gb db), but I got that down to < 30 mb by
setting the cache size to 0 and setting a low soft heap limit. That works
whe
We are looking at renovating the design of the SQLite
website and would love to have suggestions from the
community. If you have any ideas on how to improve
the SQLite website, please constribute either to the
mailing list or directly to me.
Here are some links to competing database products
that
This disk cache effect is pretty well known on this list.
Mozilla/Firefox also uses a similar technique for its sqlite database:
http://developer.mozilla.org/en/docs/Storage:Performance#Priming_the_cache
They go to the extra step of populating the sqlite page cache with
some custom code:
http
As Trevor cautioned, you run the risk of really impacting the other
applications running on the system and the system itself. As you fill
up the Windows cache manager with your file, you will push out other
relevant data including data that the OS may be using. This will cause
applications to
--- Felix <[EMAIL PROTECTED]> wrote:
> I would use sqlite in an embedded DOS system ( intel 16 bits processor ) .
>
> Do you think that is possible or sqlite work only on 32/64 bits systems?
I could be wrong, but I think sqlite expects that int and pointers are
at least 32 bit.
See if you can fi
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: quinta-feira, 8 de novembro de 2007 12:04
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] is safe to use the same database connection at the
same time in more than one thread?
>Yes. The wiki page was correct whe
Hello Renaud,
Thursday, November 8, 2007, 9:11:41 AM, you wrote:
RH> Is the mmap option part of sqlite or do we need to change the sqlite code ?
RH> If so, has somebody here already tried it ? Any source available ?
RH> What 's the order of improvement ?
RH> Renaud
>> Date: Thu, 8 Nov
--- "Maxim V. Shiyanovsky" <[EMAIL PROTECTED]> wrote:
> Suppose I have simple table:
>
> CREATE TABLE [profile_data] (
> [profile_id] INTEGER,
> [version] INTEGER);
>
> CREATE INDEX [by_id] ON [profile_data] ([id]);
>
> Why
>
> sqlite> explain query plan
>...> select distinct(profile_i
-Original Message-
>From: Salles, Joaquim Campos [mailto:[EMAIL PROTECTED]
>Sent: quinta-feira, 8 de novembro de 2007 11:45
>To: sqlite-users@sqlite.org
>Subject: [sqlite] is safe to use the same database connection at the
same >time in more than one thread?
>Is safe to use the same datab
Is the mmap option part of sqlite or do we need to change the sqlite code ?
If so, has somebody here already tried it ? Any source available ?
What 's the order of improvement ?
Renaud
> Date: Thu, 8 Nov 2007 15:54:35 +0500
> From: [EMAIL PROTECTED]
> To: sqlite-users@sqlite.org
> Subje
Paulito,
I believe from a previous post you're using the System.Data.SQLite wrapper,
right? That provides Windows-only encryption built in to the wrapper.
HTH,
Sam
---
We're Hiring! Seeking a passionate developer to join our team building Flex
based pr
"Salles, Joaquim Campos" <[EMAIL PROTECTED]> wrote:
> Hello,
>
> Is safe to use the same database connection at the same time in more
> than one thread? The bellow like that is safe:
>
> http://www.sqlite.org/34to35.html
>
> "Restrictions on the use of the same database connection by multiple
"Trevor Talbot" <[EMAIL PROTECTED]> wrote:
> Beyond that, I'm not aware of anything that would help.
>
All good advice. But you left off the obvious: Get a
faster disk drive. ;-)
--
D. Richard Hipp <[EMAIL PROTECTED]>
-
Hello,
Is safe to use the same database connection at the same time in more
than one thread? The bellow like that is safe:
http://www.sqlite.org/34to35.html
"Restrictions on the use of the same database connection by multiple
threads have been dropped. It is now safe for multiple threads to us
On 11/8/07, Julien Renggli <[EMAIL PROTECTED]> wrote:
> As I said, the "nasty" trick works and we'll live with it (writing our
> own FileSystem is not an option). We would just like to understand
> better what's happening, to know why and when the "first run" is so much
> slower. And should we rea
On 11/8/07, Jonas Sandman <[EMAIL PROTECTED]> wrote:
> How much is it for the encrypted version?
The info on that is here: http://www.hwaci.com/sw/sqlite/prosupport.html
-
To unsubscribe, send email to [EMAIL PROTECTED]
Thanks for your quick answer.
RaghavendraK 70574 wrote:
> Try this, use mmap
> (i assume u'r db is readonly)this is much faster and
> better than ifstream read. Also ifstream read can keep the data in
cache as long as no other serious
> i/o occurs.
Our DB is readwrite, though in my example reado
How much is it for the encrypted version?
Regards,
Jonas
On Nov 8, 2007 1:12 PM, Trevor Talbot <[EMAIL PROTECTED]> wrote:
> On 11/8/07, paulito santana <[EMAIL PROTECTED]> wrote:
>
> > is possible i put a password in the file that represents a SQLite database
> > ?? There is any instruction in S
On 11/8/07, paulito santana <[EMAIL PROTECTED]> wrote:
> is possible i put a password in the file that represents a SQLite database
> ?? There is any instruction in SQLite command line that allows this ?
No. drh sells a version of SQLite with encryption support, and some
others maintain their o
Try this, use mmap
(i assume u'r db is readonly)this is much faster and
better than ifstream read. Also ifstream read can keep the data in cache as
long as no other serious
i/o occurs.
U need to accept it as we work with Virtual Mem or
write your own FileSystem which is mem based and short circu
Hello,
I'm currently working on a project which is very likely to use SQLite as
data storage. Since performance is important for us, I already found on
the SQLite website many ways to optimise the code (always working in
transactions where possible, using a page size of 4096 since it's
running
In the call to create index, it looks like you're creating a duplicate
index on [id], which I believe references the default btree id (also
called rowid.) If you change that line to:
CREATE INDEX [by_id] ON [profile_data] ([profile_id]);
your index should be used (though whether indexes get use
Hello,
I wonder if sqlite3_reset() can ever fail. In particular, does sqlite3_reset()
always reset the statement even if it returns an error code?
>From the documentation and mailing list, my understanding is that
>sqlite3_reset() errors always relate to the latest (or possibly ongoing) VM
>ex
Hello,
I would use sqlite in an embedded DOS system ( intel 16 bits processor ) .
Do you think that is possible or sqlite work only on 32/64 bits systems?
Do you know an alternative to sqlite?
Thank you for your help.
Felix
Suppose I have simple table:
CREATE TABLE [profile_data] (
[profile_id] INTEGER,
[version] INTEGER);
CREATE INDEX [by_id] ON [profile_data] ([id]);
Why
sqlite> explain query plan
...> select distinct(profile_id) from profile_data;
0|0|TABLE profile_data
Does not use index?
Hei all,
is possible i put a password in the file that represents a SQLite database
?? There is any instruction in SQLite command line that allows this ?
Regards,
Paulito
59 matches
Mail list logo