SQLite doesn't have a free text search capability - the Like and Glob
functions are not free text just simple pattern matching on the scanned
text. Performance is very poor because there is no suitable index.
It's not a simple task to create free text searching - you have to create an
inverted
Hi.
I'm using SQLite for the first time and our project performs hundreds of
insert/delete operations continuously. Analysing the process with
Valgrind, we got the following report, which shows a growing of memory
allocated along the time.
==28046== 91994 bytes in 674 blocks are still
On Wed, 2005-07-06 at 09:38 -0300, Gerson Luís Fontoura Vaz wrote:
> I'm using SQLite for the first time...
>
> We are using SQLite version 2.8.15.
>
Why, oh why are you using 2.8.15 when 3.2.2 is known to be
faster, smaller, and to contain many more features???
The test suite for SQLite
Sorry, I think I was not very clear.
Valgind report shows a block of memory still reachable, not definitively
lost. This memory seems to be allocated by sqlite for internal use.
My question is if this memory still reachable can (or should) be
deallocated.
Gerson Vaz
D. Richard Hipp
On Wed, 2005-07-06 at 10:15 -0300, Gerson Luís Fontoura Vaz wrote:
> Sorry, I think I was not very clear.
>
> Valgind report shows a block of memory still reachable, not definitively
> lost. This memory seems to be allocated by sqlite for internal use.
>
> My question is if this memory still
At 13:53 06/07/2005, you wrote:
On Wed, 2005-07-06 at 09:38 -0300, Gerson LuÃs Fontoura Vaz wrote:
> I'm using SQLite for the first time...
>
> We are using SQLite version 2.8.15.
>
Why, oh why are you using 2.8.15 when 3.2.2 is known to be
faster, smaller, and to contain many more features???
"D. Richard Hipp" <[EMAIL PROTECTED]> writes:
> On Wed, 2005-07-06 at 09:38 -0300, Gerson LuÃs Fontoura Vaz wrote:
>> I'm using SQLite for the first time...
>>
>> We are using SQLite version 2.8.15.
>>
>
> Why, oh why are you using 2.8.15 when 3.2.2 is known to be
> faster, smaller, and to
On Wed, 2005-07-06 at 09:32 -0400, [EMAIL PROTECTED]
wrote:
> "D. Richard Hipp" <[EMAIL PROTECTED]> writes:
>
> > On Wed, 2005-07-06 at 09:38 -0300, Gerson LuÃs Fontoura Vaz wrote:
> >> I'm using SQLite for the first time...
> >>
> >> We are using SQLite version 2.8.15.
> >>
> >
> > Why, oh
On 7/6/05, Steve O'Hara <[EMAIL PROTECTED]> wrote:
>
> SQLite doesn't have a free text search capability - the Like and Glob
> functions are not free text just simple pattern matching on the scanned
> text. Performance is very poor because there is no suitable index.
>
> It's not a simple task
Looks like Firefox is gearing up to store some of its information in
SQLite? Does anyone know anything more about this?
http://gemal.dk/blog/2005/07/06/mozilla_firefox_bookmarks_in_for_a_rewrite/
--
Scott Baker
Canby Telephone - Network Administrator - RHCE
Ph: 503.266.8253
It's written in C already... MS VS 6
Steve
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
rg]On Behalf Of Jay Sprenkle
Sent: 06 July 2005 16:31
To: sqlite-users@sqlite.org; [EMAIL PROTECTED]
Subject: Re: [sqlite] Does SQLite have a fulltext search like MySQL?
On 5 Jul 2005, at 17:48, Michael Grice wrote:
If not, are there plans to add this?
What language are you planning to use? Perl has a bunch of full text
search modules that implement FTS on top of any DB.
Matt.
__
This
On Wed, 2005-07-06 at 08:40 -0700, Scott Baker wrote:
> Looks like Firefox is gearing up to store some of its information in
> SQLite? Does anyone know anything more about this?
>
> http://gemal.dk/blog/2005/07/06/mozilla_firefox_bookmarks_in_for_a_rewrite/
>
I've been hearing of this for some
On 7/6/05, D. Richard Hipp <[EMAIL PROTECTED]> wrote:
> On Wed, 2005-07-06 at 08:40 -0700, Scott Baker wrote:
> > Looks like Firefox is gearing up to store some of its information in
> > SQLite? Does anyone know anything more about this?
> >
> >
Is it possible to load an SQLite file database into an SQLite "in
memory" database? If so what is the most efficient method to do this?
I'm looking for the fastest possible performance. Taking out the
disk I/O seems like the way to go.
Thanks,
-John
> Is it possible to load an SQLite file database into an SQLite "in
> memory" database? If so what is the most efficient method to do this?
> I'm looking for the fastest possible performance. Taking out the
> disk I/O seems like the way to go.
create a memory database, attach the file based
assuming you open up a :memory: database:
attach 'foo.db' as bar;
create table baz as select * from bar.baz;
detach bar;
doesn't copy indexes, so you'll have to remake them. dont think it
copies triggers either.
On 7/6/05, John Duprey <[EMAIL PROTECTED]> wrote:
> Is it possible to load an
SQLite supports the blob datatype, but one can access a blob value only
as a whole. Is support planned to partially read or write a blob value?
For example in an Oracle database one can select a blob reference from a
table and can then operate on this blob reference: reading or writing
parts
>set tran_string "BEGIN TRANSACTION\n"
>foreach ...
>append tran_string "\n"
>append tran_string "END TRANSACTION\nCOMMIT TRANSACTION"
>DB eval "$tran_string"
Ray,
Someone may pipe in to correct me, but this is my understanding..
BEGIN TRANSATION, END TRANSACTION and COMMIT TRANSACTION could be
On 7/6/05, Kiel W. <[EMAIL PROTECTED]> wrote:
> >set tran_string "BEGIN TRANSACTION\n"
> >foreach ...
> >append tran_string "\n"
> >append tran_string "END TRANSACTION\nCOMMIT TRANSACTION"
> >DB eval "$tran_string"
> Ray,
> Someone may pipe in to correct me, but this is my understanding..
>
On 7/4/05, Ajay <[EMAIL PROTECTED]> wrote:
>
> Hello All,
>
> What is the maximum number that can be stored using INTEGER data type? My
> table uses INTEGER to store primary key, I store lot of records in table.
> I
> suspect that primary key will run out of limit. How can I use long instead
>
Interesting.. can multiple threads share the same in-memory database
through multiple sqlite_open()s? From what I can scrape together from
the wiki page http://www.sqlite.org/cvstrac/wiki?p=InMemoryDatabase),
it sounds like the best one could do is create the in memory db handle
once in the main
I was already expanding my SQl horizons asking this question.
What would be a reasonable action?
On 7/6/05, Jay Sprenkle <[EMAIL PROTECTED]> wrote:
>
> On 7/6/05, Kiel W. <[EMAIL PROTECTED]> wrote:
> > >set tran_string "BEGIN TRANSACTION\n"
> > >foreach ...
> > >append tran_string "\n"
> >
Ray Mosley wrote:
AS a DB rookie, I have replaced the .txt files in an Tcl/Tk application with
a SQLite database, so it still reads very much like file I/O. While in a
loop I wrote several records to my files, so now I simply do an INSERT.
I keep reading that you optimize performance by using
On Tue, 2005-07-05 at 08:52 -0500, Ray Mosley wrote:
> AS a DB rookie, I have replaced the .txt files in an Tcl/Tk application with
> a SQLite database, so it still reads very much like file I/O. While in a
> loop I wrote several records to my files, so now I simply do an INSERT.
> I keep
On Wed, 2005-07-06 at 17:49 -0400, Kiel W. wrote:
> On 7/4/05, Ajay <[EMAIL PROTECTED]> wrote:
> >
> > Hello All,
> >
> > What is the maximum number that can be stored using INTEGER data type? My
> > table uses INTEGER to store primary key, I store lot of records in table.
> > I
> > suspect
Hello, John!
It would be nice to have option that just loads the db file into
memory or otherwise caches the contents wholly in memory. Are there
any caching options in sqlite that would mirror this behavior?
You could set the cache size as big as your database file (via pragma).
This
On Wednesday 06 July 2005 05:12 pm, Ray Mosley wrote:
> I was already expanding my SQl horizons asking this question.
> What would be a reasonable action?
Anything but a seg fault ;)
display the error perhaps?
>
> On 7/6/05, Jay Sprenkle <[EMAIL PROTECTED]> wrote:
> > On 7/6/05, Kiel W. <[EMAIL
You could create a new os_ram.c file, with new versions of these functions, but
instead of read/writing to disk you are read/writing from a linked list of
filenames, of which each could contain a ptr to the file data. You would then
be responsible for copying it back to disk at some point.
On 7/6/05, D. Richard Hipp <[EMAIL PROTECTED]> wrote:
> On Wed, 2005-07-06 at 08:40 -0700, Scott Baker wrote:
> > Looks like Firefox is gearing up to store some of its information in
> > SQLite? Does anyone know anything more about this?
> >
> >
30 matches
Mail list logo
