On Tue, Apr 01, 2014 at 01:08:59PM +, Harmen de Jong - CoachR Group B.V.
wrote:
> We have built our own SQLite database server application and are considering
> making this open source. Since there will be some time involved into making
> it an open source project and maintaining it, we
On Mon, May 05, 2014 at 05:00:08PM -0400, Richard Hipp wrote:
> On Mon, May 5, 2014 at 4:53 PM, Patrick Donnelly wrote:
>
> > Hi,
> >
> > I have an INSERT that looks like
> >
> > INSERT INTO T
> > SELECT ...
> >
> > which I'm running numerous times a second that
On Tue, Aug 23, 2011 at 09:28:35AM +0200, Sébastien Escudier wrote:
> Hi,
>
> I am currently using sqlite on an ext3 file system with ordered mode.
> But we have serious performance issues when sqlite calls fsync,
> especially on RAID devices.
>
> We noticed that disabling fsync in sqlite OR
On Thu, Sep 15, 2011 at 05:47:47AM +, Grice, Lynton (L) wrote:
> Hi Ross,
>
> Many thanks for your response, I really appreciate it and will definitely
> drop you a quick email if I have any issues with the build.
>
> I am going to install GCC onto the AIX 5.3 box and will give it a try. I
On Mon, Sep 19, 2011 at 02:42:42PM +0100, Jaco Breitenbach wrote:
> Hi Simon,
>
> Thanks for the reply.
>
> On 19 September 2011 13:23, Simon Slavin wrote:
>
> > > I run the database (3.7.7.1) in WAL mode, with checkpointing performed at
> > 10
> > > minute intervals.
> >
On Sun, Sep 25, 2011 at 11:08:38AM +0100, Katie Blake wrote:
> Hello,
Hello, Katie!
>
> I hope that this is the correct list to send this question.
> I am trying to use SQLite on a Gumstix Linux module running Angstrom armv7l
> GNU/Linux. (32-bit).
>
> I have installed the sqlite packages
On Sun, Sep 25, 2011 at 09:52:00PM +0100, Christian Smith wrote:
> On Sun, Sep 25, 2011 at 11:08:38AM +0100, Katie Blake wrote:
> >
> > I hope that this is the correct list to send this question.
> > I am trying to use SQLite on a Gumstix Linux module running Angstrom armv7l
Ludvig Strigeus uttered:
Assuming I have an autovacuum database that primarily stores 32k blobs. If I
add/remove lots of rows, will this lead to excessive fragmentation of the
overflow chains, or does Sqlite do anything to try to unfragment the pages
belonging to a single row?
I believe
Kalyani Tummala uttered:
I am planning to use sqlite as a database for storing and retrieving
media data of about 5-10k records in a device whose main memory is
extremely small. A sequence of insert statements increasing the heap
usage to nearly 70K(almost saturating point) which is crashing my
[EMAIL PROTECTED] uttered:
When you have a connection with multiple attached databases and the
connection acquires an exclusive lock, does it always lock all attached
databases or does it keep track of which databases require the lock?
1st process:
C:\Documents and
Eduardo Morras uttered:
At 19:32 01/06/2007, you wrote:
When you have a connection with multiple attached databases and the
connection acquires an exclusive lock, does it always lock all attached
databases or does it keep track of which databases require the lock? Does
using separate
Rich Rattanni uttered:
The databases will be in flux, and I didnt necessairly want to suspend
the application that is performs reads and writes into the database.
A simple copy worries me because it seems like messing with SQLITE on
the file level is dangerous since you circumvent all the
Andre du Plessis uttered:
How can one optimize the creation of the journal file. The problem is
this, for our system which is an event based one each message needs to
be insterted and committed to the database (guaranteed), this results in
a commit per insert, this was obviously unacceptably
Asif Lodhi uttered:
Hi Kees,
Thanks for replying.
On 6/17/07, Kees Nuyt <[EMAIL PROTECTED]> wrote:
>... thankful if you experts would give me an "accurate" and fair
>picture of the crash-recovery aspects of SQLite - without any hype.
I'm not sure if you would qualify this as hype, but
Uma Krishnan uttered:
Hello:
Is lemon parser modular and extensible?
Extensible to do what? It generates parsers, and is self contained. It
does a single job, and does it well. What more could you ask for?
Thanks
Uma
Asif Lodhi <[EMAIL PROTECTED]> wrote:
Hi Everybody,
I have
Uma Krishnan uttered:
Hey, There's no need to be offensive. I did not mean to be critical. Far
from it, it does a great a job (far more than I'm capable of producing).
What I was trying to find out was, if it is possible for a .y files to
be broken such that it can be built on top on other .y
pompomJuice uttered:
I suspected something like this, as it makes sense.
I have multiple binaries/different connections ( and I cannot make them
share a connection ) using this one lookup table and depending on which
connection checks first, it will update the table.
What is your working
Gilles Ganault uttered:
Hello
As we move from a 2.8.x file-based solution to a 3.x c/s solution, we'll have
to convert databases from one format to the other.
What's the easiest way to do this?
sqlite olddb .dump | sqlite3 newdb
Thank you
G.
Christian
--
/"\
\ /ASCII
John Stanton uttered:
The Sqlite date/time routimes have a resolution to seconds, not milliseconds.
If you want milliseconds from SQL implement your own user defined functions
which give you milliseconds. You would access the time functions using the
API of the underlying OS.
You might
Joe Wilson uttered:
CREATE TABLE 'Months'
(
IDMonth INTEGER PRIMARY KEY NOT NULL,
MonthRef INTEGER
);
(where MonthRef is the date of the first day of the month - created in the code)
Using what epoc?
CustomerData
--
CREATE TABLE
Scott Baker uttered:
Christian Smith wrote:
If you use the julianday representation, the integer component is the
number of days since "noon in Greenwich on November 24, 4714 B.C", with
the fractional part being the fraction of that day. Hence, the
resolution is determined by the
Lokesh Babu uttered:
Hello Folks,
When I perform the DELETE operation on a Table using In-Memory Database
(":memory:"), the memory usage increases.
I tried using PRAGMA auto_vacuum=1; /* result - nothing works */
Even I tried using VACUUM table_name; /* this too isn't work */
if I perform
memory
back to the operating system. I don't know of specific instances of libc
that do this, so I can't help further, sorry.
Thanks
On 8/1/07, Christian Smith <[EMAIL PROTECTED]> wrote:
Lokesh Babu uttered:
Hello Folks,
When I perform the DELETE operation on a Table using In-
.
Christian Smith wrote:
Lokesh Babu uttered:
Hello Folks,
When I perform the DELETE operation on a Table using In-Memory Database
(":memory:"), the memory usage increases.
I tried using PRAGMA auto_vacuum=1; /* result - nothing works */
Even I tried using VACUUM table_name; /* this too
A common issue of high latency transactions. SQLite has a high
per-transaction overhead, which can be amortized across multiple INSERTs
or UPDATEs to improve the average INSERT rate. You are doing a single
INSERT per transaction, so wrap multiple INSERTs inside a single "BEGIN"
... "END"
Edwin Eyan Moragas uttered:
hi group,
i have several small questions for the group any
experiences or thoughts shared would be greatly
appreciated.
1) anybody used sqlite as a sql server? i'm thinking
of say using the embedded sqlite in PHP5 or similar.
2) anybody ever implemented something
Igor Mironchick uttered:
Thx, very helpfull reply. One more question: is it need to do "END" after
"BEGIN" or enought "COMMIT"?
You can use "COMMIT". Probably should do, as it is more descriptive about
what is happening. Check the docs for transaction commands:
Edwin Eyan Moragas uttered:
On 8/6/07, Christian Smith <[EMAIL PROTECTED]> wrote:
2) anybody ever implemented something like a single
process of sqlite doing queries for a lot of networked
clients?
A few people have implemented such a solution. It loses one of the
benefits of
[EMAIL PROTECTED] uttered:
[EMAIL PROTECTED] wrote:
Ken <[EMAIL PROTECTED]> wrote:
Recompiled with:
gcc -DSQLITE_THREADSAFE -I. -I../src
^^^
Should be -DSQLITE_THREADSAFE=1
The =1 is important in this case.
This problem will likely come up again. To try and work
Once you get your first row back (corresponding to (a==1), simply halt
there and sqlite3_finalize() or sqlite3_reset the statement. You control
the execution and how many rows you want back.
RaghavendraK 70574 uttered:
Hi,
Ok.
Is there any way to tell the VDBE to stop execution moment it
Joe Wilson uttered:
--- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote:
In 3.5, cache can be shared between
all threads, but shared cache is still disabled by default. You have to
invoke sqlite3_enable_shared_cache() to turn it on. I put a comment in
the documentation that we might turn shared
Wilson, Ron uttered:
It has been a very long time since I have tinkered with lex/yacc but my
current project requires a parser. I'm thinking of learning lemon.
Frankly, the sqlite code base is far more complex than what I will
implement. Is anyone willing to share a lemon parse.y code
John Stanton uttered:
Jay Sprenkle wrote:
On 6/14/06, RohitPatel <[EMAIL PROTECTED]> wrote:
Any solution to that (which does not force end-user of app to manage
sqlite
file fragments or to defragment disk) ?
A scheduled task or cron job is trivial to implement and does not
add any
Bogus�aw Brandys uttered:
[EMAIL PROTECTED] wrote:
Mikey C <[EMAIL PROTECTED]> wrote:
Please implement table and row level locking. :-)
People commonly believe that doing so must be easy. I
certainly get a lot of requests for it from people who
think they know how. But in fact, row-level
Ҷ�� uttered:
Hi,all
I'm trying to bulid a database engine based on uc/os-II RTOS with my own
customized file system(similar with FAT16, but not exactly the same). I
find that SQLite is a good choice.
I have read the SQLite source code for several days, but I still have no
idea where I
Insun Kang uttered:
Hi.
I tested big deletes performance and big insert performance on a Windows CE
device in various cache size configurations.
( 1MB, 100KB, 50KB )
Insert 3000 records performs within 23sec, 43sec and 61sec, with respect to
each cache size configuration.
However, delete 1000
Igor Tandetnik uttered:
Ran <[EMAIL PROTECTED]> wrote:
Thanks for your reply. I know that I should lock the file before
copying it,
and the "BEGIN IMMEDIATE" is indeed a nice trick.
However, I think I didn't explain my problem clearly. I would like to
copy
that file _without_ using the sqlite
Jay Sprenkle uttered:
On 6/21/06, Christian Smith <[EMAIL PROTECTED]>
Adding to the free list will touch each page at most once, and thus
caching adds no benefit (and has no loss for a smaller cache.)
Inserting may touch each page multiple times, for such operations as
rebalancing th
Igor Tandetnik uttered:
Christian Smith
<[EMAIL PROTECTED]> wrote:
Igor Tandetnik uttered:
You want to enable sharing. Pass FILE_SHARE_READ | FILE_SHARE_WRITE
as the third parameter.
Surely not FILE_SHARE_WRITE! You don't want other processes writing
the database while you're c
Message -
From: "Christian Smith" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Wednesday, June 21, 2006 7:04 PM
Subject: Re: [sqlite] How to port SQLite to a uc/os-II OS with customized file
system?
Ҷ uttered:
Hi,all
I'm trying to bulid a database engine based on
[EMAIL PROTECTED] uttered:
Two SQLite APIs, sqlite3_exec() and sqlite3_mprintf(), return
strings in memory obtained from a malloc-like memory allocator.
The documentation has always said that you need to use sqlite3_free()
in order to free those strings. But, as it happens, it has
until now
[EMAIL PROTECTED] uttered:
Christian Smith <[EMAIL PROTECTED]> wrote:
My own personal opinion on these coding style issues is if the API
requires special handling of cleanup, then the API should do the cleanup.
Returning an allocated string that requires special cleanup r
Dennis Cote uttered:
Christian Smith wrote:
Yes, of course, Windows sticks it's oar in again. Going back to the
previous DLL discussion, this alone is surely confirmation of why the
Windows DLL system sucks.
This really has nothing to do with the Windows DLL system. It is simply the
case
Andrew Piskorski uttered:
On Tue, Jun 27, 2006 at 04:14:37PM +0100, Christian Smith wrote:
Anyway, it's not difficult to provide thread local storage. HP-UX's
netdb.h functions (gethostbyname etc.) are fully re-entrant despite
returning 'static' data, for example. Other UNIXs got hamstrung
Lukáš Neumann uttered:
Hello,
I am using SQLite DLL version 3.2.1 to access a single file database. I
use sqlite3_exec() to call this simple query:
BEGIN; INSERT INTO Messages (IDMessage, Body) VALUES (1054, 'Test');
COMMIT;
When the application runs under Windows XP, the query takes
Dennis Cote uttered:
Your call to sqlite3_free_table is correct.
You free the error message by calling sqlite3_free(tresult.err_msg).
If either pointer returned by sqlite3_get_table() is NULL, then no memory was
allocated, so there is no need to free it, however I believe it should be
safe
Henrik Goldman uttered:
Hi,
I have a new HP-UX maching running latest official OS B.11.23 and has gcc
4.1.1.
The problem is that when I try to configure I get an error:
bash-3.00# ./configure CFLAGS="-O2 -lp64" --enable-threadsafe
checking build system type... ia64-hp-hpux11.23
checking
Pat Wibbeler uttered:
A quick search through the sqlite source release led me to believe that
the source may be coded around endian issues. I guess what I'm looking
for is affirmation or denial of my cursory reading.
If the source is endian dependent, how does sqlite configure and/or make
ahochan uttered:
I'm building a dictionary application that will run on Nintendo DS and PSP.
I'm considering using sqlite to store the database which will will be
read-only, and embedded on rom.
Is it possible to get sqlite to read the database directly from such a
pre-allocated memory area?
[EMAIL PROTECTED] uttered:
Mikey C <[EMAIL PROTECTED]> wrote:
Not sure what you mean there DRH, but I set compression on one of my database
files on NTFS and file size shrunk from 1,289,216 bytes to 696,320 bytes.
And of course the whole compression / decompression process is completely
Gussimulator uttered:
I've been using SQLite for a very short period of time and so far Its
doing a great job for my application (single user, quite a big amount of
data though).
Now, since theres a lot of repetitive data, I thought that compressing
the database would be a good idea, since,
[EMAIL PROTECTED] uttered:
=?ISO-8859-1?Q?Tobias_Rundstr=F6m?= <[EMAIL PROTECTED]> wrote:
Is there something wrong with sqlite3_bus_timeout on NetBSD?
I've not had any problems with sqlite3_busy_timeout on Linux.
And I do not have NetBSD handy for testing. Not sure what the
problem might
Tzu-Chien Chiu uttered:
OK. But what I don't understand is: is this (lack of sqlite3_exec16) by
design?
The sqlite3_exec function is a deprecated interface used by earlier SQLite
releases. New applications should use, for performance reasons if nothing
else,
Hello JOIN expoerts:)
I have the following schema:
CREATE TABLE instances (
instanceid integer primary key,
type,
instance);
CREATE INDEX instances_type_instance ON instances(type,instance);
CREATE TABLE instance_fields (
instanceid references instances(instanceid),
field,
subscript
) );
DRH,
Is this expected behaviour? I'd have thought the manifest typing would
have seen to that, but it appears that join fields need to be the same
type.
Christian
Christian Smith uttered:
Hello JOIN expoerts:)
I have the following schema:
CREATE TABLE instances (
instanceid integer
[EMAIL PROTECTED] uttered:
Christian Smith <[EMAIL PROTECTED]> wrote:
select
FROM instances as i
inner join instance_fields as count using(instanceid)
inner join instance_fields as first using (instanceid)
inner join instance_fields as last using (instanceid)
inne
[EMAIL PROTECTED] uttered:
"Brandon, Nicholas (UK)" <[EMAIL PROTECTED]> wrote:
I don't want to hijack this thread (not too much anyway) but this got me
thinking about JOINs since I have a database that uses a similar concept
(one table holds a number of key-value pairs for another).
As I
Keiichi McGuire uttered:
This is a bit confusing, especially since if I compile it using gcc it will
compile w/o any problems. What would this "incompatibility" mean and what
would a solution be to make it compatible and be found by the compiler?
Chances are that the libsqlite.a you're
Bull219 uttered:
Dear all,
I am developping a freeware which uses SQLite. One of my beta testers
informed me about an issue he had: with his DB, following the query which is
sent to the DB, I have the error in the subject of this email. I did some
testing, and when I succeeded in
Inline.
Jens Miltner uttered:
Hi all,
I need to create a temporary table holding ID column values from a number of
tables, so that I have a unique way to access the data for display purposes:
say I have 2 related tables
[snip schema]
When displaying a filtered subset of the persons with
Keiichi McGuire uttered:
I'm a bit stuck on this one problem
I have this simple table that has two fields: id and value.
What I want to do is to get the largest id (the last entry) and then add an
arbitrary number to the value that's in the same entry as that one, and put
the result in the
John Newby uttered:
Hi Martin, I'm not sure, I don't use VB that often, I just need to use it
for my Uni project at the moment.
With all due respect to your University, but VB sucks as a teaching
language IMO. Doesn't your Uni have better development tools? Any
professor that advocates VB
Jay Sprenkle uttered:
On 7/13/06, Christian Smith <[EMAIL PROTECTED]> wrote:
You can't use aggregate functions in WHERE clauses. Also, you can't use a
select as the value in an insert. You can insert from the results of an
insert.
uh...It seems to work:
The OP was trying to use a
the pragma twice, once to count the number of columns,
allocate the array, then again to fill the array. It's not a heavyweight
operation.
Many thanks
John
On 13/07/06, Christian Smith <[EMAIL PROTECTED]> wrote:
John Newby uttered:
> Hi Martin, I'm not sure, I don't use VB that often, I
Vivek R uttered:
Hi ,
I am New bee to the group and SQLite. Can anyone explain me How to port the
SQLite to DVD or Consumer products or any other Embedded Systems. Where I
can look for it ? What and all things to be considered while porting. Which
is the best version to port to consumer product
Cesar David Rodas Maldonado uttered:
I am wondering if it will have a better performance if i split every index
and table into different files, i know that i will loose the LITE concept,
but i am wondering if it will have a better performance...
Not unless each individual file is on a
w b uttered:
Hi all,
Just had a quick question with regards to the order of the columns
within a create table statement
I have a few tables that use the BLOB type for storing various lengths
of binary data and I was wondering if its better (more efficient) to
always declare columns of this
michael cuthbertson uttered:
Brannon:
Thank you for your thoughts.
To be clear, the 'optimize for speed' setting in MY release is actually
slower than MY debug version - I know nothing about Ralf's settings.
That issue is separate from SQLiteSpy - I didn't mean to conflate them.
And the issue
is compatible with VxWorks.
If I'm not mistaken, the standard version should be compatible with
VxWorks. Your best bet is to compile it up and try it.
Please guide me.
Thanks and Regards,
Vivek R
On 7/14/06, Christian Smith <[EMAIL PROTECTED]> wrote:
Vivek R uttered:
> Hi ,
>
chtaylo3 uttered:
Set the global variable sqlite3_temp_directory to any
directory you want and it tries that directory first.
Ok, fair enough. But why do you try and open the directory? Why can you
just try and create the tmp file there and deal with it if it's not allowed?
I'm asking
chtaylo3 uttered:
Christian,
Or you could just fix the permissions on your temp directories. If the
files in */tmp are sensitive, they should be protected. The file name
themselves should not be sensitive.
I'm not aware of many installations using the permissions you use for temp
[EMAIL PROTECTED] uttered:
Jens Miltner <[EMAIL PROTECTED]> wrote:
OTOH, our customers might also have antivirus software installed, so
this still would not be a solution :(
Does anybody have advice on how to make sqlite work smoothly with
antivirus software [on Windows]? (Probably depends
prabhu kumaravelu uttered:
Please unsubscribe me from sqlite
Try sending an email to this address:
[EMAIL PROTECTED]
And stop spamming the list.
From: "Igor Tandetnik" <[EMAIL PROTECTED]>
Reply-To: sqlite-users@sqlite.org
To: "SQLite"
Subject: [sqlite]
Gerry Snyder uttered:
Finally, get it right:
sqlite> create table test(f integer primary key autoincrement, v int default
0);
sqlite> insert into test (v) values (1);
sqlite> insert into test (v) values (2);
sqlite> insert into test (v) values (NULL);
sqlite> select * from test;
1|1
2|2
3|
Rob Richardson uttered:
In SQL Server, I can write a stored procedure that looks something like
this:
[snip]
Other features available in SQL Server stored procedures include while
loops, temporary tables, and the FETCH command to retrieve data from a
resultset one row at a time.
I have
Stan uttered:
Hi,
I need user function for WHERE clause.
But I don't know what type of parameters to use for such function:
SELECT * FROM Table WHERE MYFUNC(ColumnName, IntValue).
Above all - how to returm value to WHERE and what type?
Is there any example (tutorial or explanation) in C or
Olaf Beckman Lapr� uttered:
Hi,
Is it possible to read the undamaged parts of a damaged .db file? This
way I can copy the undamaged parts to another database. Or support to
repair the .db file in such a way that it becomes readable again and the
undamaged parts can be read.
You can try
Mikey C uttered:
Is there any performance or other gain in writing:
select sum(column_a) + sum(column_b)
vs
select sum(column_a + column_b)
The second should be faster, as I'd expect aggregate functions to be more
expensive than expression additions. The second would have half the
John Stanton uttered:
In general you must expect Sqlite to use more of all resources compared to a
flat file. After all Sqlite is a flat file with additional logic.
Except updates and selective reads will be cheaper in general, as less IO
is required due to additional logic.
Storage will
Alexander Lamb uttered:
Well, sorry, but I did exactly that:
1) When I do the PRAGMA command the file is created (I can see it appearing
in the explorer)
2) After the create table, if I do PRAGMA legacy_file_format; I indeed
receive "1" as an answer.
However,
I ".quit" then go back into
chetana bhargav uttered:
Hi,
I have few questions regarding triggers,
* If we want to have trigger for some condition and if multiple
applications create a trigger for the same condition providing different
C callback functions (which I guess is possible through
sqlite3_create_function),
Daniel Önnerby uttered:
Hi everyone!
I'm just a bit curios if it would be possible to make like a C precompiler or
a macro of some kind that compiles/interpret the SQL-statements to bytecode
just like the sqlite_prepare does but does this when compiling/precompiling
your application instead
Clay Dowling uttered:
Installing gcc is an excellent idea, but I would not be entirely surprised
to learn that the actual failure is in sed. SCO and awk/sed do not have a
happy history, with incompatible changes having been introduced at times.
Nope, I reckon the SCO compiler just doesn't
Laura Longo uttered:
On 8/21/06, Laura Longo <[EMAIL PROTECTED]> wrote:
I've tried also executing the query "begine exclusive" before the
"update",
and "commit" to end the entire routine, and the query that now returns the
exit code 5 (database locked) is "begin exclusive", I don't know if
Jay Sprenkle uttered:
hidden variables might very well not be a problem, if it was done that
way on purpose.
It should never be done on purpose. It is obfuscation pure and simple.
There is never a good reason to do this, other than perhaps hiding a
global variable (and even that is not a
Sarah uttered:
plus, I'm using sqlite-source-3_3_5.
I also find a wired phenomenon:
When I trace into sqlite3Parser(pEngine, TK_SEMI, pParse->sLastToken,
pParse);
the next executed statement pointed by debugger does not match with the
real one, It seems there are one or two lines space.
[EMAIL PROTECTED] uttered:
I don't think NULL callback and error pointer will be the reason. Because I've
seen this kind of usage in the list for several times.
Anyway, I'll try later and report the result to the list.
If it is a misaligned-pointer problem, what can I do?
You say you are
Abhilash Menon uttered:
After a lot of reading and experimenting, I was able to get SQLite3
working with Visual C++.net 2003.
Here is what I did
...
Built the project and it worked without any issues. If you have a
database ready you are ready to test and it works fine
Wow! You poor soul!
P Kishor uttered:
looking at the SQL supported by SQLite, I see no mention of TRUNCATE.
Not in the SQL clauses supported, nor in the clauses omitted. Is
TRUNCATE a weird beast?
I don't think it's standard SQL. At least not SQL92 that SQLite aims to
implement.
TRUNCATE is an optimised
PY uttered:
Hi All,
I have a problem about LIMIT & OFFSET profermance.
Due to the limitation of memory, I could not get all of the query result at
a time.
In our soluction, we use the LIMIT and OFFSET to avoid the problem of memory
issue.
we observed the performance of LIMIT & OFFSET, it looks
Mikey C uttered:
What are peoples thoughts on implementing optimistic concurrency control in
SQLite?
Not an option. SQLite has a single writer database locking protocol which
can't handle multiple writers, so the issue of concurrency control is
moot.
One way is modify the where
Cesar David Rodas Maldonado uttered:
I meen, If SQLite has two index and very large Index (about 10.000.000 each
one) how do i merge it, I mean (index1 = index2 for every one and limit it
in thousand).
Understand?
I guess not.
Are you trying to do an INNER JOIN merger on the two indexes?
Mikey C uttered:
Hi,
Maybe I didn't make the question clear. I'm not talking about locking and
multiple writers. I'm talking about optimistic concurrency control in a
disconnected environment.
Two processes (say a webserver). One reads some data and presents it to a
user (open - read -
James Mills uttered:
Hi Richard,
When I mean high-traffic I would imagine more than 1 hit/s.
I do want to clear something up though (if you could):
If a site using sqlite takes 700ms to load and there are
two simultaneous (as simultaneous as one can get) hits
to the site, say user A and user
Isaac Raway uttered:
Thank, I will look at that (away from my dev machine for the day).
One other related question, are there plans to expand the functionality of
ALTER TABLE? I am working on a feature that could benefit greatly from
REMOVE/RENAME COLUMN. As it stands, I am going to have to
Sarah uttered:
Hi, John Stanton
I really really appreciate your warm help.
That's great if you can send me the codes of B tree and B+ tree.
Many thanks in advance.
My requirements for data access are as follows:
-all the data are stored in non-volatile memory instead of volatile memory
-the
Manzoor Ilahi Tamimy uttered:
I found that Version 2.8 was much Faster than 3.6 using ":memory:", 30
Seconds and 60 seconds in case of 2.8 and 3.6 respectively.
can I use 2.8 in my project when i have a huge amount of data to handle.
Version 2 used a Red/Black balanced tree in :memory:,
Peter De Rijk uttered:
--On Friday 27 October 2006 15:31, [EMAIL PROTECTED] wrote:
When a table is indexed, INSERT performance is logorithmic in the
number of rows in the table and linear in the number of indices.
This is because entries have to be inserted into the index in
sorted
[EMAIL PROTECTED] uttered:
I'm working on a new API routine for SQLite and I have
questions for the community.
The working name of the new api is sqlite3_prepare_v2().
sqlite3_prepare_v2() works like sqlite3_prepare() in that
it generates a prepared statement in an sqlite3_stmt
structure. The
chetana bhargav uttered:
Hi,
I have a question regrading indexes,
When I open a connection,
Will indexes be loaded into memory. If one of the tables in the DB, the
connection for which I have opened, has an index.
If, so is there any way to selectively load/unload that from memory.
1 - 100 of 360 matches
Mail list logo