You can significant increase access speed by "ANALYZE" in some cases.
--
Biomechanica Artificial Sabotage Humanoid
Teg <[EMAIL PROTECTED]> wrote:
>
> dhc> Recompile version 3.5.2 with -DSQLITE_MEMORY_SIZE=1000
> dhc> or however much memory you want SQLite to use. This will
> dhc> create a static array of char[] of size 1000 (or whatever
> dhc> other size you give it) and use that instead of malloc()
In general I'm agree with Kishor comments, specially those related to the
ability to include comments to the documentation pages and the need of
*more* examples.
I recognize that the present design has its charm (those of a Web site made
by an engineer) but I recognize that has found some
Renaud HUILLET wrote:
Thanks for your reply,
Indeed, the windows API is not the same at the Unix one (mmap), but I think I
have a wrapper somewhere that can handle both.
Anyone has been trying the mmap for SQLite ?
Renaud
Date: Thu, 8 Nov 2007 10:15:24 -0500
From: [EMAIL PROTECTED]
To:
Michael Scharf wrote:
[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
Hi,
I was using Sqlite library 3.3.8 before upgrading it to version 3.4.2 on
Linux.
Right after upgrade I noticed that the CPU load of my application, which
is shared linked to the library, increased considerably.
Profiling revealed that version 3.4.2 seems to have some kind of problem
with the
Ram Drive involve a context switch(from user to Kernel) and hence there is loss
of performance!!!
Check this factor also.
regards
ragha
**
This email and its attachments contain confidential information
> There is a physical constraint here. If you want to verify that your
> data is safely written to non-volatile storage you have to live with the
> latency. If that is unimportant to you you can relax the ACID
> requirements and get faster writes, but when you do that there is no
> crying
Holger Eitzenberger <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I was using Sqlite library 3.3.8 before upgrading it to version 3.4.2 on
> Linux.
>
> Right after upgrade I noticed that the CPU load of my application, which
> is shared linked to the library, increased considerably.
>
> Profiling
Thanks, everybody, for the excellent feedback and suggestions
for revising the SQLite website. Please keep the comments
coming.
Regarding the basic "look" of the site, we were considering
using a style similar to the once found at ActiveState
http://www.activestate.com/
However, as we
Does anybody here knows sqlite internals (especially database file locking
algorithm)?
Or am I only one who meet this bug?
May be someone could persuade me that it's not a bug?
Concerning the problem -
I have some table (not so big at my point of view but with 6 records).
I start
[EMAIL PROTECTED] writes:
>> Profiling revealed that version 3.4.2 seems to have some kind of problem
>> with the DB if created with version 3.3.8 of the library. These are the
>> first lines of the profiled data on an (despite sqlite) basically idle
>> system:
>>
>> samples %app name
One thing I really like about the current home page is the listing of the
past 4-5 versions, the date when they were released and what changed. It is
so easy to see what has changed since the version that I happen to be on.
That may not need to be on the front page necessarily (although I like
"Maxim V. Shiyanovsky" <[EMAIL PROTECTED]> wrote:
>
> I start transaction and delete most of records
>
> After this sqlite fails on "select from sqlite_master" (or any other query)
> because it extend lock levelĀ to exclusive lock when deleting records.
>
> It reset exclusive lock on
[EMAIL PROTECTED] wrote:
A rough prototype of what a revised website might look like
can be seen at
http://sqlite.hwaci.com/
Short, simple, and sweet. I like it.
My only specific comment was going to be a request to make the page for
datatypes easy to find. Until I made it a book
Richard, thanks a lot!
I was completely sure I use the same connection, but indeed ...
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, November 09, 2007 6:06 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] sqlite lock error
"Maxim V. Shiyanovsky"
[EMAIL PROTECTED] wrote:
Thanks, everybody, for the excellent feedback and suggestions
for revising the SQLite website. Please keep the comments
coming.
Regarding the basic "look" of the site, we were considering
using a style similar to the once found at ActiveState
I am looking for anybody who has managed to compile sqlite3 and build up any
kind of application using arm-wince-mingw32ce tool.
--
View this message in context:
http://www.nabble.com/Mingw32ce-tf4778576.html#a13669983
Sent from the SQLite mailing list archive at Nabble.com.
Julien said in the original post:
> I've been doing some test with a ~100 MB database
on a real fast physical disk it would take < 1 sec to read
the entire database. On a slow drive like on my laptop,
it takes 3 sec, and on my external USB drive it takes 5 sec.
> Now the first time I run my
On Nov 9, 2007 3:11 PM, <[EMAIL PROTECTED]> wrote:
> http://sqlite.hwaci.com/
i like it! i like it so much, in fact, that i'll probably buy the software! ;)
> happy with the content of the homepage. (Suggestions for
> what should appear on the homepage are welcomed.)
a) What is sqlite? (A
--- [EMAIL PROTECTED] wrote:
> A rough prototype of what a revised website might look like
> can be seen at
>
> http://sqlite.hwaci.com/
Instead of:
Current Status
As of 2007-11-05 20:49:21 UTC, version 3.5.2 of SQLite is stable.
There are no known issues effecting database
>
> Please continue to provide feedback.
>
Assuming the build process is fairly automated and not too onerous to
implement I would like to see 'nightlys/weeklys' source and precompiled
binaries of SQLite. I would imagine like me, many of us are behind
company firewalls with no facility for
Mark Spiegel wrote:
> [...]
Thanks for the explanation. Yes, I'll have to make sure not to use this
technique when the file is too large. But I think there is definitively
an improvement for us to pull data in cache whenever possible.
> Given that you can't write your own VFS, there is
Hi-
I'm currently using SQLite 3.4.1 and have been reading with interest the
large database thread. I learned about the soft heap limit feature and was
considering using it.
While reading about the bug fixes for 3.4.2 and soft heap limit, I came
across a sample of setting the soft heap limit to
> > One more thing, did raising the limit on the number of pages SQLITE
> > can cache internally have any effect?
>
> I just tried (hadn't noticed that option before) to go from 2000 to 4000
> and 8000, without noticing any difference. I might try next week to
> raise the page size to 50k and see
The font change to
font-family: "Verdana" "sans-serif";
makes a huge difference - much more professional looking.
--- [EMAIL PROTECTED] wrote:
> A rough prototype of what a revised website might look like
> can be seen at
>
> http://sqlite.hwaci.com/
Regarding the basic "look" of the site, we were considering
using a style similar to the once found at ActiveState
http://www.activestate.com/
However the tendency in computers screen is wider than until now. Today the
standard is about 1440 pixels x 900, so a unique horizontal arrange y
>
> I just tried (hadn't noticed that option before) to go from
> 2000 to 4000 and 8000, without noticing any difference. I
> might try next week to raise the page size to 50k and see if
> it makes a difference?
>
On the presumption the Sqlite allocates new pages on the page boundary I
Hello Julien,
JR>
JR> I can give you a few timings I have to give you an idea:
JR>
JR> Initialisation: connects to DB, pro-compile some queries, load
JR> structured data (SELECT * FROM Objects; i.e. sequentially, no blobs)
JR> Load Blobs: load 1/4 of all Blobs (each ~23k of size, I just
On 09/11/2007, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> This is indeed a sad commentary on the state of the
> world wide web that it is now necessary to specify
> a font on every web page Oh well.
What's about CSS? It should help in this case.
--
Biomechanica Artificial
--- bash <[EMAIL PROTECTED]> wrote:
> I am owner of web site with ~ 15k uniq visitors/day and I can say this
> is not really true.
> For example this is statistics from google analytics:
> 1.1024x76842.51%
> 2.1280x1024 27.73%
> 3.1280x80010.43%
> 4.1152x864
Just put the font-family in your .css file and all the pages that refer
to your .css will conform. You already said that the demo site was .css
driven...
RW
Ron Wilson, Senior Engineer, MPR Associates, 518.831.7546
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On 09/11/2007, A.J.Millan <[EMAIL PROTECTED]> wrote:
>
> > Regarding the basic "look" of the site, we were considering
> > using a style similar to the once found at ActiveState
> >
> > http://www.activestate.com/
> >
>
> However the tendency in computers screen is wider than until now. Today
bash <[EMAIL PROTECTED]> wrote:
> On 09/11/2007, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> > This is indeed a sad commentary on the state of the
> > world wide web that it is now necessary to specify
> > a font on every web page Oh well.
>
>
> What's about CSS? It should help in
--- [EMAIL PROTECTED] wrote:
> Joe Wilson <[EMAIL PROTECTED]> wrote:
> > The font change to
> >
> > font-family: "Verdana" "sans-serif";
> >
> > makes a huge difference - much more professional looking.
> >
>
> This is indeed a sad commentary on the state of the
> world wide web that it is
--- [EMAIL PROTECTED] wrote:
> There is a new look up on the demo site at
>
>http://sqlite.hwaci.com/
>
> It looks good on Firefox and Safari, but IE6 renders
The 'T' in 'SUPPORT' in the horizontal toolbar is cut off in my Linux
Firefox 2.0.0.8 browser. I have a screen resolution of
> There is a new look up on the demo site at
>
>http://sqlite.hwaci.com/
>
> It looks good on Firefox and Safari, but IE6 renders
> it incorrectly. Being entirely in the unix world now,
> I am of a mind to ignore the IE6 problem and just let
> lingering IE6 users see a goofed up display. I
Joe Wilson <[EMAIL PROTECTED]> wrote:
>
> You chose to embed the CSS settings on each page to avoid the round
> trip to the web server. You can always put the css info in a separate
> file, and define it only once for the entire site. It should reduce
> the number of bytes sent over the wire.
>
Joe Wilson wrote:
> No need to say it's stable or recommended - it's assumed. Otherwise it
> wouldn't appear on the home page.
I disagree. 3.5.0 appeared, even though discussion was that it was
relatively experimental. It's *good* to be explicit about this.
-- James
Not a terribly useful comment but was just glancing through the new
look and noticed a typo:
http://sqlite.hwaci.com/about.html
"We believe that General Electric uses SQLite in some product or
another because they twice wrote the to SQLite developers "..
"wrote the to "
On Nov 9, 2007
Joe Wilson <[EMAIL PROTECTED]> wrote:
>
> It takes time to get all popular browsers working, but it leaves a
> good first impression with potential users of your software.
>
It seems like a better solution would be to do the website
without any CSS and then spend the days or weeks of
drh wrote:
> There is a new look up on the demo site at
>
>http://sqlite.hwaci.com/
It does look much "prettier" than the current live site.
I note the common "affect"/"effect" typo in the sentence
"There are no known issues effecting database integrity
or correctness.", where this should
"Mark Wyszomierski" <[EMAIL PROTECTED]> wrote:
> Not a terribly useful comment but was just glancing through the new
> look and noticed a typo:
>
> http://sqlite.hwaci.com/about.html
>
> "We believe that General Electric uses SQLite in some product or
> another because they twice wrote the to
> I don't think the extra bandwidth is an issue. Dan points out that
> if you put the CSS in a separate file, then sometimes a browser
> will render the page without CSS, then when the CSS arrives a
> fraction of a second later, everything shifts. I'd rather avoid
> that.
>
> I am now also told
That looks fantastic (in firefox).
Ron Wilson, Senior Engineer, MPR Associates, 518.831.7546
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, November 09, 2007 1:11 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Suggests for improving the SQLite
Another solution is to design your css for standard browser and then
just create a iefixes.css file to load only in IE that contains the
various fixes for that browser.
The trick is to add that lines in the head section:
---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/
I vote for (4).
---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/
http://www.sqlabs.net/realsqlserver/
On Nov 9, 2007, at 7:45 PM, [EMAIL PROTECTED] wrote:
"Mark Wyszomierski" <[EMAIL PROTECTED]> wrote:
Not a terribly useful comment but was just glancing through the new
I'd echo the suggestion for making the directions for import/export more
prominent (which may mean simply linked from multiple places).
Perhaps I'd also suggest linked to the command-line tool information
from several places, maybe including the SYNTAX area. Newcomers seem
to be able to miss
I think 4 looks great,
Mark
On Nov 9, 2007 1:45 PM, <[EMAIL PROTECTED]> wrote:
> "Mark Wyszomierski" <[EMAIL PROTECTED]> wrote:
> > Not a terribly useful comment but was just glancing through the new
> > look and noticed a typo:
> >
> > http://sqlite.hwaci.com/about.html
> >
> > "We believe
--- James Dennett <[EMAIL PROTECTED]> wrote:
> Joe Wilson wrote:
> > No need to say it's stable or recommended - it's assumed. Otherwise it
> > wouldn't appear on the home page.
>
> I disagree. 3.5.0 appeared, even though discussion was that it was
> relatively experimental. It's *good* to be
[EMAIL PROTECTED] wrote:
>
>(1) http://sqlite.hwaci.com/v1/ No CSS of any kind.
>(2) http://sqlite.hwaci.com/v2/ CSS menus with rounded corners
>(3) http://sqlite.hwaci.com/v3/ CSS menus with square corners
>(4) http://sqlite.hwaci.com/v4/ CSS font specification
Richard,
I just recently discovered that IE supports "conditionl comments", which allow
you to, among other things, load specific CSS in IE. For detail, see
http://msdn2.microsoft.com/en-us/library/ms537512.aspx
I was able to use this feature to my advantage on a project to load the main
CSS
(4) is my choice. I'm not fond of the drop down menu scripts on
webpages anyway... but that's just me.
RW
Ron Wilson, Senior Engineer, MPR Associates, 518.831.7546
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, November 09, 2007 1:45 PM
To:
--- [EMAIL PROTECTED] wrote:
> I don't think the extra bandwidth is an issue. Dan points out that
> if you put the CSS in a separate file, then sometimes a browser
> will render the page without CSS, then when the CSS arrives a
> fraction of a second later, everything shifts.
That's not the case
--- [EMAIL PROTECTED] wrote:
> I put up 4 variations. Please, everyone, offer your opinions:
>
>(1) http://sqlite.hwaci.com/v1/ No CSS of any kind.
>(2) http://sqlite.hwaci.com/v2/ CSS menus with rounded corners
>(3) http://sqlite.hwaci.com/v3/ CSS menus with square
Joe Wilson wrote:
>
> --- James Dennett <[EMAIL PROTECTED]> wrote:
>
> > Joe Wilson wrote:
> > > No need to say it's stable or recommended - it's assumed.
Otherwise it
> > > wouldn't appear on the home page.
> >
> > I disagree. 3.5.0 appeared, even though discussion was that it was
> >
[EMAIL PROTECTED] wrote:
Joe Wilson <[EMAIL PROTECTED]> wrote:
The font change to
font-family: "Verdana" "sans-serif";
makes a huge difference - much more professional looking.
This is indeed a sad commentary on the state of the
world wide web that it is now necessary to specify
a font
Did you run your test using ReadFile?
Brandon, Nicholas (UK) wrote:
I just tried (hadn't noticed that option before) to go from
2000 to 4000 and 8000, without noticing any difference. I
might try next week to raise the page size to 50k and see if
it makes a difference?
On the
[EMAIL PROTECTED] wrote:
bash <[EMAIL PROTECTED]> wrote:
On 09/11/2007, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
This is indeed a sad commentary on the state of the
world wide web that it is now necessary to specify
a font on every web page Oh well.
What's about CSS? It should
I like 3 too. There's a minor glitch on Firefox - increasing font size
causes the right side of menu bar to be whited out but display when
cursor hovers. Is this the bug Joe refers to below?
Mark
> -Original Message-
> From: Joe Wilson [mailto:[EMAIL PROTECTED]
> Sent: Friday, November
Joe Wilson wrote:
(3) http://sqlite.hwaci.com/v3/ CSS menus with square corners
In Firefox 2.0.0.8, press "CTRL +" a couple of times to see the render
problem. If I press "CTRL -" it renders properly.
On larger screen resoltions, sometimes the default fonts are a bit bigger
than
That sounds great and all, but lucky you that you get to work in an
office that actually lets you install firefox. Many corporations
severely limit user freedom on company hardware. I'm not one of them,
but I have many friends that work in these environments where only
'authorized' tools are
it has been my experience that the outfits who use Harold down at the
Golf Club or Snake and Lizard at the Pub to give the management their
"Microsoft Only" policy are not ready to make an exception to that
policy for Sqlite.
Wilson, Ron wrote:
That sounds great and all, but lucky you that
Yep. The 'T' in SUPPORT disappears for me.
The fonts in Linux may differ slightly from Windows.
Maybe my machine does not have Verdana and is using the sans-serif
backup font choice.
(2) has the same issue.
--- "Evans, Mark (Tandem)" <[EMAIL PROTECTED]> wrote:
> I like 3 too. There's a minor
--- John Stanton <[EMAIL PROTECTED]> wrote:
> Joe Wilson wrote:
> >>(3) http://sqlite.hwaci.com/v3/ CSS menus with square corners
> >
> > In Firefox 2.0.0.8, press "CTRL +" a couple of times to see the render
> > problem. If I press "CTRL -" it renders properly.
> >
> > On larger
I hope this doesn't offend, but perhaps the best solution is to outsource
the website to someone or a company that specializes in websites and design
(with your stated simplicity goals in mind of course). We certainly
wouldn't want a graphic designer hacking away at the SQLite engine, so isn't
On 11/9/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> I put up 4 variations. Please, everyone, offer your opinions:
>
>(1) http://sqlite.hwaci.com/v1/ No CSS of any kind.
>(2) http://sqlite.hwaci.com/v2/ CSS menus with rounded corners
>(3) http://sqlite.hwaci.com/v3/
On 11/9/07, Joanne Pham <[EMAIL PROTECTED]> wrote:
> I knew that SQLite doesn't allow concurrency for both read and write at the
> same time.
> My application is written in C++ so Is there any way that we can check if
> there is any connection to the database so the second connection needs to
Hi Trevor,
I have an application to writh to database with begin transaction and end
transaction.
Before end transaction another application try to connect to the database to
read the data and in the middle of the read of the second application
the first application isues the end transaction.
Hi-
Could someone please remind me how I can download SQLite code for version
3.4.2 from CVS? Was there some sort of tag made that I can use?
I'm hesitant to upgrade to 3.5.x just because I'm not sure how much it has
been test driven and we are close to release. Maybe I am being overly
On 11/9/07, Joanne Pham <[EMAIL PROTECTED]> wrote:
> I have an application to writh to database with begin transaction and end
> transaction.
> Before end transaction another application try to connect to the database to
> read the data and in the middle of the read of the second application
>
First off, I would like to say that although I have a lot of experience
with programming, most of it is in C#/Java and I do not have a lot of
experience with C++, although I have been working with SQLite for years.
I am attempting to create my own extension to use with SQLite but am
having
Mark Brown wrote:
Could someone please remind me how I can download SQLite code for version
3.4.2 from CVS? Was there some sort of tag made that I can use?
I'm hesitant to upgrade to 3.5.x just because I'm not sure how much it has
been test driven and we are close to release. Maybe I am being
--- "Samuel R. Neff" <[EMAIL PROTECTED]> wrote:
>
> I hope this doesn't offend, but perhaps the best solution is to outsource
> the website to someone or a company that specializes in websites and design
> (with your stated simplicity goals in mind of course). We certainly
> wouldn't want a
Joe Wilson wrote:
> --- "Samuel R. Neff" <[EMAIL PROTECTED]> wrote:
> >
> > I hope this doesn't offend, but perhaps the best solution is to
> outsource
> > the website to someone or a company that specializes in websites and
> design
> > (with your stated simplicity goals in mind of course). We
Hi Dennis-
Thanks for the reply.
How do I know what version of the file was part of 3.4.2 and what is part of
3.5? I'm seeing version numbers of 1.171, for example.
Thanks,
Mark
> Mark,
>
> Go to the download page, copy the link for the file you want
> (with the
> current 3..5.2 version
Ahh...I think I figured it out. Clicking the "Show Milestones" button was
very helpful!
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
--- James Dennett <[EMAIL PROTECTED]> wrote:
> Joe Wilson wrote:
> > Also, non-technical people would be a better judge of which website
> > design is appealing.
>
> Appealing *to* non-technical people? Why would a website on an embedded
> database wish to appeal primarily to such an audience?
Mark Brown wrote:
How do I know what version of the file was part of 3.4.2 and what is part of
3.5? I'm seeing version numbers of 1.171, for example.
Mark,
I was talking about using the sqlite download page at
http://www.sqlite.org/download.html.
If you right click on a link (like the
--- P Kishor <[EMAIL PROTECTED]> wrote:
> On 11/9/07, Joe Wilson <[EMAIL PROTECTED]> wrote:
> > --- James Dennett <[EMAIL PROTECTED]> wrote:
> >
> > > Joe Wilson wrote:
> > > > Also, non-technical people would be a better judge of which website
> > > > design is appealing.
> > >
> > > Appealing
James Dennett wrote:
Joe Wilson wrote:
--- "Samuel R. Neff" <[EMAIL PROTECTED]> wrote:
I hope this doesn't offend, but perhaps the best solution is to
outsource
the website to someone or a company that specializes in websites and
design
(with your stated simplicity goals in mind of
[EMAIL PROTECTED] wrote:
There is a new look up on the demo site at
http://sqlite.hwaci.com/
It looks good on Firefox and Safari, but IE6 renders
it incorrectly. Being entirely in the unix world now,
I am of a mind to ignore the IE6 problem and just let
lingering IE6 users see a goofed up
[EMAIL PROTECTED] wrote:
Regarding the basic "look" of the site, we were considering
using a style similar to the once found at ActiveState
http://www.activestate.com/
However, as we started to prototype this, we wrote down a
very simple CSS/Javascript-free template and after looking
at it,
[EMAIL PROTECTED] wrote:
Joe Wilson <[EMAIL PROTECTED]> wrote:
It takes time to get all popular browsers working, but it leaves a
good first impression with potential users of your software.
It seems like a better solution would be to do the website
without any CSS and then spend the days or
[EMAIL PROTECTED] wrote:
"Mark Wyszomierski" <[EMAIL PROTECTED]> wrote:
I put up 4 variations. Please, everyone, offer your opinions:
(1) http://sqlite.hwaci.com/v1/ No CSS of any kind.
(2) http://sqlite.hwaci.com/v2/ CSS menus with rounded corners
(3)
For what reason would "non-technical" types need to look on the SQLite
website? :-)
I kind'a like it the way it is. Plain and simple, with no over wrought
graphics and other worthless fluff.
It is a website for a very bare bones, plain and simple database. Those
who access it are not looking for
Great idea! Why don't we give them little printable chits for free
chips and beer as well?!
Just the facts m'am. -- Jack Webb
> -Original Message-
> From: John Stanton [mailto:[EMAIL PROTECTED]
> Sent: Friday, November 09, 2007 5:51 PM
> To: sqlite-users@sqlite.org
> Subject: Re:
John Stanton wrote:
How about having adding a social networking capability so that
non-technical people will have a reason to use the website. You cannot
expect to attract them with a frugal and highly functional embedded
database library.
LOL!
- Richard
88 matches
Mail list logo