ned this to
> developers around me and they are intrigued. You are storing a database
> file as blob in a database? We are curious as to the application. I am
> assuming the database being stored is a collection of sensor or event data?
>
> On Fri, Apr 26, 2019 at 5:48 PM Mohd
Hi, is there a vfs that could be used to open a blob column as a database?
thanks.
Radzi.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Hi,
I thought that I hit a bug with SQLite 3.28.0 and 3.27.1 when my in-list
contains too many items the code breaks here:
The sqlite3_step just exit without returning any error code.
best regards,
Radzi
___
sqlite-users mailing list
sqlite-users@maili
select from (select ... )
must have alias. It should be
select from (select ... ) a
On Tue, May 20, 2014 at 9:38 AM, YAN HONG YE wrote:
> Hi,
> Sorry, I use mysql, not in sqlite, in mysql ,I run this command, the
> console show this error: do you know why?
> Thank you very much!
>
> mysql>
fossil is a webserver by itself with sqlite as the database engine. AFAIK,
there's no scripting language used on the server. All written in C.
On Mon, Dec 30, 2013 at 1:02 AM, Tim Johnson wrote:
> * Stephan Beal [131229 07:48]:
> > On Sun, Dec 29, 2013 at 5:35 PM, Tim Johnson wrote:
> >
> >
who have to deal with more than one database engine would prefer to use
use such a pragma to adjust such implementation behaviour.
pragma set_text_match_probability %value%
pragma set_pattern_match_probability %value%
Ibrahim
___
sqlite-users
Further comment :
If you want to implement a sequence of records in a table you can do it
much faster with only on record to update when you insert a value in the
middle of this sequence. For this purpose you shouldn't use a pseudo
array but a single or double ended queue with only one trigger
workaround for your problem :
create table t1 (pk integer primary key, name text, seq integer) ;
create unique index idxt1 on t1 (name,seq) ;
insert into t1 values (1, 'blue', 1) ;
insert into t1 values (2, 'blue', 2) ;
insert into t1 values (3, 'blue', 3) ;
insert into t1 values (4, 'blue', 4)
On 06.09.2013 20:52, Igor Tandetnik wrote:
On 9/6/2013 1:05 PM, ibrahim wrote:
Perhaps you should really try it out cause my suggestion is totally
different from yours it uses a temporary table it works.
create table t1 (pk integer primary key, name text, seq integer) ;
You missed the whole
On 05.09.2013 20:20, Peter Haworth wrote:
I have a table with the following (simplified) structure
PKeyINTEGER PRIMARY KEY
NameTEXT
Sequence INTEGER
The Name/Sequence pair of columns is defined as UNIQUE
I need to insert a new row into a point between two sequence numbers. For
example, if the
On 06.09.2013 18:30, Dominique Devienne wrote:
On Fri, Sep 6, 2013 at 5:41 PM, ibrahim wrote:
You can let sqlite handle the creation of a temporary table by :
update t1 set seq=seq+1 where pk in (select pk from t1 where seq >= 3
order by seq desc) ;
afterwards you can insert.
Unless
On 06.09.2013 18:30, Dominique Devienne wrote:
On Fri, Sep 6, 2013 at 5:41 PM, ibrahim wrote:
You can let sqlite handle the creation of a temporary table by :
update t1 set seq=seq+1 where pk in (select pk from t1 where seq >= 3
order by seq desc) ;
afterwards you can insert.
Unless
On 05.09.2013 20:20, Peter Haworth wrote:
I have a table with the following (simplified) structure
PKeyINTEGER PRIMARY KEY
NameTEXT
Sequence INTEGER
The Name/Sequence pair of columns is defined as UNIQUE
I need to insert a new row into a point between two sequence numbers. For
example, if the
On 16.08.2013 18:03, Gary Weaver wrote:
Thanks to you and Richard for the links and info. Concurrency is not outlandish
to expect, especially when it works in OS X and just not in the Ubuntu vm in
Travis, but I now understand that these are expected problems.
___
On 15.08.2013 21:39, Gary Weaver wrote:
SQLite varies between file is encrypted/not a DB errors and database disk image
is malformed. It would seem consistent with SQLite not handling concurrent
processing in this particular environment or with the version of SQLite since
3.7.7 is fine in OS X
after sqlite3_reset () all bound parameters keep their values they are
not unbound or nullified by default so for that purpose you would have
to call sqlite3_call_bindings ()
see link http://www.sqlite.org/c3ref/clear_bindings.html
this is not necessary if you want to keep all bound values exc
On 02.08.2013 10:14, techi eth wrote:
Come across one issue with conditional query execution.
Query: UPDATE COMPANY SET Name= 'test' WHERE ID = 2;
According to my understanding if no ID = 2 is present in table then error
should return but it return with SQLITE_OK however Name value is not
change
On 30.07.2013 14:49, fnoyan...@yahoo.com wrote:
Yes, it is slow actually. But I could not do it with SQL. I wish I could do
more with SQL than code, which would give a good performance improvement.
From overall application point of view, I may be considering using threads to
read from databas
On 16.07.2013 13:26, Bernd Lehmkuhl wrote:
On 16 Jul 2013, at 4:39am, Bernd Lehmkuhl wrote:
Am 15.07.2013 22:26, schrieb Simon Slavin:
The following two statements do different things.
INSERT INTO myTable VALUES (01)
INSERT INTO myTable VALUES ('01')
Can you tell what's being done in your s
On 21.04.2013 05:15, 刘运杰 wrote:
Ok,I do not make my means clearly. I mean 60 seconds after my program
started,not token 60 seconds to load database file.
Now, I got the reason of sqlite abnormal IO writing,it about batch insert.
Here is my usecase:
One table about 4 column and 500 row,the conte
On 05.04.2013 17:01, Dan Kennedy wrote:
On 04/05/2013 09:08 PM, Rob Collie wrote:
Yeap, I'm on Visual Studio 2012. I've created a console app:
sqlite3 *oDatabase;
int returnValue;
returnValue = sqlite3_open_v2("file://C:/Newfolder/testing.db",
&oDatabase, SQLITE_OPEN_CREATE, NULL);
if
On 05.04.2013 16:47, Rob Collie wrote:
sqlite3_open_v2("file://C:/Newfolder/testing.db",
> > > >& oDatabase, SQLITE_OPEN_CREATE, NULL);
Can you try :
returnValue = sqlite3_open_v2 ("C:\\Newfolder\\testing.db", &oDatabase,
SQLITE_OPEN_CREATE, NULL) ;
Use double backslash also after "file://
On 05.04.2013 14:54, Rob Collie wrote:
Hello there,
For my sins, I'm trying to create a library allowing our legacy fortran
code to work with SQL.
Calling this from fortran...
CALL EXECUTESQL('dbTest'//CHAR(0), cQuery, iReturnValue)
...runs the following code, and yet the error returned is 'SQ
Those measurements asume that you store each blob in a seperate file. So
the raw file access seems slower for smaller blob sizes.
If you use external blob storage do it in raw clusters like i suggested
in a previous post (size limit 32/64 MB) and store your blobs on page
boundaries (page size
In reference to your needs one more suggestion :
>> If you put the blobs outside of a sqlite database and store your
householding, indexing data inside your sqlite data i would suggest to
use journal mode = on because your journal file and database file
without the blobs has a small amount and
From : http://www.sqlite.org/pragma.html#pragma_journal_mode
The OFF journaling mode disables the rollback journal completely. No
rollback journal is ever created and hence there is never a rollback
journal to delete. The OFF journaling mode disables the atomic commit
and rollback capabilitie
On 29.03.2013 20:17, Jeff Archer wrote:
I have previously made an apparently bad assumption about this so now I
would like to go back to the beginning of the problem and ask the most
basic question first without any preconceived ideas.
This use case is from an image processing application. I ha
On 29.03.2013 19:42, Jeff Archer wrote:
From: "James K. Lowden"
To: sqlite-users@sqlite.org
Your experiment is telling you different: transaction control costs more
than I/O.
But shouldn't transactions be disabled when journal_mode = off? Maybe that
is a faulty assumption. If so, what is the
On 28.03.2013 14:03, Jeff Archer wrote:
On Thu, Mar 28, 2013 at 8:24 AM, ibrahim wrote:
On 28.03.2013 13:09, Jeff Archer wrote:
On Wed, Mar 27, 2013 at 6:35 PM, Simon Slavin
wrote:
Reasonable figures. With 5764 writes to the disk in separates
transactions you have quite a lot of reading of
On 28.03.2013 13:09, Jeff Archer wrote:
On Wed, Mar 27, 2013 at 6:35 PM, Simon Slavin wrote:
Reasonable figures. With 5764 writes to the disk in separates transactions you
have quite a lot of reading of data plus 5764 attempts to update the database
file. The updates have to be done in the
On 27.03.2013 22:55, Jeff Archer wrote:
On Wed, Mar 27, 2013 at 5:46 PM, David King wrote:
I am populating a database with 5764 records using the exact same data set
each time into a newly created file.
When I use no explicit transactions (default atomic commit) it takes 17.7
seconds.
When I se
On Thu, Sep 20, 2012 at 12:58 AM, Igor Tandetnik wrote:
> On 9/19/2012 12:51 PM, joe.fis...@tanguaylab.com wrote:
>
>> Too bad SQLite doesn't yet support SQL Window Functions.
>>
>> Are there any SQLite Extension Libraries that support "SQL:2003 type
>> Window Functions"?
>> I specifically need LE
On Wed, Aug 15, 2012 at 11:19 PM, markus ruettimann <
markus.ruettim...@trapezegroup.com> wrote:
> Hi,
> We are facing problems when the sqlite database () is used within an
> application that runs as a Win7 service under the local system account.
> The application is written in Java and we use th
Could it be that the .ext is used by the OS or other apps with some caching
scheme? Try different extension...
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Tuesday, June 26, 2012, Andrew Rondeau wrote:
> Because my time is valuable; and my peers' time is valuable as well.
>
> For example, if I make a Mac application, I can target the SQLites shipped
> with Mac. Problem solved, my valuable time can go to something else.
>
>
Since I don't want any o
Hi,
I guess, if you could sort your input data by col1 and col2; going thru the
list and insert only when col1 and col2 are different from previous row,
should speed up the loading too.
Regards,
Radzi.
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@
On 25-Oct-2011, at 2:53 PM, Dan Kennedy wrote:
> This was fixed and then I forgot to follow up here. I should have.
> Sorry about that. It's fixed here:
>
> http://www.sqlite.org/src/ci/3126754c72?sbs=0
>
> Either updating to the latest trunk or just applying the linked
> patch to fts3.c shoul
On 18-Oct-2011, at 6:52 PM, Dan Kennedy wrote:
>
>
> On 10/18/2011 05:02 PM, Mohd Radzi Ibrahim wrote:
>> Hi,
>>
>> This is my table schema:
>>
>> CREATE VIRTUAL TABLE LocationFTS using FTS4
>> (
>> name text,
>> address tex
Hi,
This is my table schema:
CREATE VIRTUAL TABLE LocationFTS using FTS4
(
name text,
address text,
email text,
remark text,
telno text,
contact text,
isDeleted text
);
This select statement gives floating point error in both sqlite3.e
On 15-Sep-2011, at 2:55 AM, Magnus Thor Torfason wrote:
>
> I then ran a query grouping employees by job:
>
> > select ename, job from emp group by job;
> "ENAME", "JOB"
> ==
> "FORD", "ANALYST"
> "MILLER", "CLERK"
> "CLARK", "MANAGER"
> "KING", "PRESIDENT"
> "TURNER", "SALE
Hi,
I was searching for any reference to reserved characters used in FTS4, but
failed to find any.
I have problem with query with - ftstable match 'width 5" '
But it's ok with - ftstable match 'width 5'
to fix this, I replaces every double-qoute in query with empty space.
My question, is ther
Hi,
Try use www.libxl.com that has C/C++/C#/Delphi interface to read excel files.
The rest are just normal sqlite commands.
On 28-Mar-2011, at 9:17 AM, Deepti Marathe wrote:
>
> Hi,
>
> I am new to SQLite and am using it for the first time. I need to create an
> application using C# that wil
On 10-Mar-2011, at 6:52 AM, Jay A. Kreibich wrote:
> On Wed, Mar 09, 2011 at 11:37:46PM +0100, Armin Kunaschik scratched on the
> wall:
>> On Wed, Mar 9, 2011 at 11:28 PM, Igor Tandetnik wrote:
>
>>> INSERT OR REPLACE is indistinguishable from a DELETE followed by INSERT.
>
>> Is it really DE
On 21-Dec-2010, at 5:02 AM, Richard Hipp wrote:
> (2) Create your own custom mini-SQL-server using SQLite and your own
> protocol for your applications to talk to that min-server over the network.
The key here is to define your own app-specific protocol for communication
between client and serv
r reason, my client don't want anybody to copy the
database, except together with the exe.
> Monday, October 25, 2010, 1:17:13 AM, you wrote:
>
> KN> On Sun, 24 Oct 2010 20:57:15 +0800, Mohd Radzi Ibrahim
> KN> wrote:
>
>>> Hi,
>>> I am planning
Hi,
I am planning to deploy my sqlite database together with the exe file. Is there
a way to open the sqlite database with a file handle and starting offset of the
file, as read-only?
Thank you for any suggestion.
regards,
Radzi.
___
sqlite-users mai
Have you not consider loading the whole rows into memory array and use simple
string search or regexp? I'm sure 10,000 records could be search a blink.
best regards,
Radzi.
On 6-Aug-2010, at 3:42 AM, Sam Roberts wrote:
> I'd appreciate any suggestions on good ways to do this, I'm neither an SQL
Hi,
You could also use another open source layer for SQLite3, wxSQLite3 project on
sourceforge. It's uses wxWidgets cross-platform C++ toolkit.
best regards,
Radzi.
On 7-Jul-2010, at 6:09 AM, smengl90 wrote:
>
> I found out that including the header file alone is not enough. I need to
> link
Am 14.02.2010 18:53, schrieb Max Vlasov:
>> This is appx. 500MB cache, why not trying with 2,000,000 cache size ? :-)
>>
>>
>>
> Hmm, managed to increase it to only 1,000,000 (x1024) size, larger values
> bring to "Out of memory" finally, and this values (1G) allows up to
> 6,000,000 fast rec
n't use
the primary key to access your data but that's not what the op asked for
as far as i understood his question.
Ibrahim.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Am 10.02.2010 18:19, schrieb Alberto Simões:
> Supose a table with a key that is a string (say, words from 1 to 10
> characters) or a table with a key of integers.
>
> How different is the efficiency on fetching one record on these tables?
>
>
If you look into the documentation for "create tabl
Am 05.02.2010 22:33, schrieb Vasanta:
> Kittayya:
>
> My issue is, I already have imported table in the Database, there alreay
> around 1000 records in that table where ROWID is from 1 to 1000, now system
> generates new events, where ROWID again starts from beginning from 1, now
> these new events
I think "worth" should be more accurate.
- Original Message -
From: "Jean-Christophe Deschamps"
To: "General Discussion of SQLite Database"
Sent: Friday, November 06, 2009 9:47 AM
Subject: Re: [sqlite] Local data structures vs sqlite
> You read 'worse' instead of 'worst', of course!
t while when you
use your own unique integer as a primary key you will have one index
table less and the B+Tree will use your integer. Less space, faster
access without losing anything.
Hope this simple description will help.
Ibrahim
___
sqlite-u
Hi,
at the first sight i'd suggest that you reorder the rows of your index :
it is most likely that chr and strand will have many equal values in your
example - especially chr. When chr is the first field of your Index than the
path to find first differences in the btree to find the matching i
Jan schrieb:
> thx Ibrahim. Give me some time to digest yours and other suggestions.
>
> But it seems I will end up with a adjunct list PLUS something. Of course
> you are right: I need to store many other information for each animal. I
> definitely need to use a database (sqlite
One further advice :
The fastest solution for your Problem would be to create a Array with
fixed size Entries to describe the relationship between animals.
in C you would simply end up with a struct like :
struct ancestors {
integer id_father ;
integer id_mother ;
} ;
If you have a con
especially when
you only store a few thousand values. You would get a bit faster results
with hashing. But before you invent your proprietary engine i'd advice
to use a relational database with sql. I think you'll store more than
only par
Assumptions : Your database scheme contains this declarations
CREATE TABLE data (
num INTEGER,
di CHAR(4),
data CHAR(12),
time1 INTEGER,
time2 INTEGER,
format CHAR(1)
);
CREATE UNIQUE INDEX i_data ON data (
num, di, time1
);
You want to do :
A) Inse
ts which are used during code
generation and the generation of the amalgamation with only C this would
make the whole thing simpler to port and more independent from any
external tools or plattforms and it would also make it possible to use
all of the creation mak
Fam. Sera schrieb:
> Is there a reason why the command line interpreter supports more functions
> while the dll does not?
>
> I would like to create an application using SQLite with and in memory
> database. I have some big text files (csv), which can be imported nicely by
> the command line int
You should use
sprintf(buf, "CREATE TABLE %s(x double, y double)", tableName);
then use prepare and execute using from that string.
- Original Message -
From: "Mike McGonagle"
To: "General Discussion of SQLite Database"
Sent: Tuesday, January 13, 2009 3:43 AM
Subject: [sqlite] Is
It seems to works either way.
I'm just wondering is there any hidden reason that single quote is
preferred? Portability?
Or is double-qoute has some kind of special meaning that we should use it
for that special purpose?
-radzi-
- Original Message -
From: "P Kishor"
To: "General Di
The syntax is wrong.
INSERT INTO TEST_TABLE(CONTENTS) VALUES ("Hello. World!");
is the correct one.
-radzi-
- Original Message -
From: "aditya siram"
To:
Sent: Monday, December 15, 2008 1:04 PM
Subject: [sqlite] Adding data with periods
> Hi all,
> I'm having trouble adding data wit
You should handle this in your client program. Even in MS SQL or Oracle, it
will not return any resultset.
If you were to use left join, you may get it as NULL for any missing links.
rgd,
Radzi.
- Original Message -
From: "aivars" <[EMAIL PROTECTED]>
To:
Sent: Monday, December 01, 2008
Could you just use ORDER BY 1 ?
best regards
-- radzi --
- Original Message -
From: "li yuqian" <[EMAIL PROTECTED]>
To:
Cc: "Dimitar Penev" <[EMAIL PROTECTED]>; "Mark" <[EMAIL PROTECTED]>
Sent: Tuesday, February 12, 2008 1:56 PM
Subject: [sqlite] Help for sqlite syntax
> Hi guys,
>
> i
Hi,
I used SQLite to move "data-cube" from server to client. The server hosts
data in MS SQL databases. There is a server-app that run query based on some
input send by client program. The server then run MSSQL query and generate a
SQLite db consisting of some tables (fact, dimensions, etc), zi
Hi,
The Precompiled Binary for Windows : the command-line sqlite-3_5_5.zip still
contain the 3.5.4 version
regards,
Radzi.
- Original Message -
From: <[EMAIL PROTECTED]>
To:
Sent: Friday, February 01, 2008 1:33 AM
Subject: [sqlite] Version 3.5.5 Released
SQLite version 3.5.5
On 21-Jan-2008, at 3:12 PM, Dan wrote:
On Jan 21, 2008, at 1:24 PM, Mohd Radzi Ibrahim wrote:
Hi,
I was trying to add a primary key to existing table but could not.
"alter table custsales add constraint pk_custsales primary key (id,
type)"
Is this supported? Is there a differ
Hi,
I was trying to add a primary key to existing table but could not.
"alter table custsales add constraint pk_custsales primary key (id, type)"
Is this supported? Is there a different syntax to do this?
best regards,
Radzi.
---
This is my 2 cents. Maybe there's better way to do this:
select
id,
amount,
(select amount from tablename where id=t.id and sno < t.sno limit 1)
as oldAmount
from tablename t
br
Radzi.
On 14-Jan-2008, at 8:14 PM, Vishal Mailinglist wrote:
Hi
sno | id | amount
1|
transaction
support sqlite has to write into the journal files as well. i want
to avoid
this too.
Thanks,
Rasanth
On Dec 26, 2007 11:34 AM, Mohd Radzi Ibrahim <[EMAIL PROTECTED]>
wrote:
On the contrary, sqlite work much-much faster when insert/update is
done within BEGIN and COMMIT;
rega
On the contrary, sqlite work much-much faster when insert/update is
done within BEGIN and COMMIT;
regards,
Radzi.
On 26-Dec-2007, at 12:14 PM, Rasanth Akali Kandoth wrote:
Hi All,
I have an application which inserts large number of rows into a
table, where
transaction support is not necessa
I'm using Visual Studio 2005 with wxSQLite3 wrapper. I have this
error at this line :
SQLITE_PRIVATE const unsigned char sqlite3UpperToLower[];
the error says:
.\..\wxsqlite3\sqlite3\src\sqlite3.c(6187) : error C2133:
'sqlite3UpperToLower' : unknown size
any suggestion on how to bypas
How about dumping and import into new db?
- Original Message -
From: "Colin Manning" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, July 25, 2007 7:05 AM
Subject: [sqlite] Saving an in-memory database to file
Hi
If I create an in-memory database (by opening with ":memory:"), then add
t
I've run SQLite3 inWindows, it's store up it surely did not truncate the
decimal point - up to 15 significant digits...
regards,
Radzi.
- Original Message -
From: "folabi" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, July 10, 2007 3:20 AM
Subject: [sqlite] storing floating point values in
Is C1 in transaction? If it is, commit will enable C2 'see' the new table.
regards,
Radzi.
- Original Message -
From: "Vivien Malerba" <[EMAIL PROTECTED]>
To:
Sent: Friday, May 11, 2007 4:19 PM
Subject: [sqlite] Multiple connections to the same database and CREATE TABLE
command
Hi
Could it be that the data where *sql is pointing to is being re-used
somewhere?
--radzi.
- Original Message -
From: <[EMAIL PROTECTED]>
To:
Sent: Thursday, May 10, 2007 3:54 PM
Subject: [sqlite] create table error
the following is my test code. just create table.
rc = sqlite3_o
How about this?
update tablename set newcolname=(case rowid when 1 then 1 else 2 end);
best regards,
Radzi
- Original Message -
From: "Tomash Brechko" <[EMAIL PROTECTED]>
To:
Sent: Saturday, May 05, 2007 8:09 PM
Subject: Re: [sqlite] how to add a new column quickly
On Sat, May
My 2 cents:
create table Objects(id integer primary key, name text);
create table Attributes(id integer primary key, name text);
create table ObjectAttributes(objectID integer, attributeID integer, order
integer, type integer, value text, version text);
- Original Message -
From: "Mic
Hi,
I'm running 3.3.15. No problem at all. Maybe your version does not have this
implemented yet...
best regards,
Radzi.
- Original Message -
From: "Stef Mientki" <[EMAIL PROTECTED]>
To:
Sent: Monday, April 16, 2007 10:14 PM
Subject: [sqlite] trim available ??
hello,
As I read h
Hi,
If you are using C++, then try hash_map. I've used this on strings with more
that 50,000 records - in memory. Very fast. Much easier to program than
BerkeleyDB.
- Original Message -
From: "Lloyd" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, April 11, 2007 11:20 PM
Subject: Re: [sq
Use sqlite3_last_insert_rowid
- Original Message -
From: "Arora, Ajay" <[EMAIL PROTECTED]>
To:
Sent: Thursday, March 29, 2007 12:19 AM
Subject: [sqlite] RE: Maintaining Master-Child relationships
Can anyone please look into my query,
I've tables
Master ( id integer primary key,
- Original Message -
From: "John Stanton" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, March 28, 2007 7:42 AM
Subject: Re: [sqlite] CREATE INDEX performance
I retract the overflow page theory on your compelling evidence and now
understand better what it is doing after looking at the VDB
Hi,
I'm using MS VS 2005 (SQLite 3.3.9) and having problem re-building the
component. I've just included all the source code inside my project and
compile. With version 3.3.8 it works fine, but with current (3.3.9) it's
giving me missing sqlite3SrcListAddAlias.
Any files should be included whi
t;[EMAIL PROTECTED]>
To:
Sent: Sunday, December 03, 2006 8:21 PM
Subject: Re: [sqlite] How do I speed up CREATE INDEX ?
"Mohd Radzi Ibrahim" <[EMAIL PROTECTED]> wrote:
Hi,
I was loading a file to sqlite (3.3.8), and it took 4 mins to load 6
million rows (with no index). But th
- Original Message -
From: "P Kishor" <[EMAIL PROTECTED]>
To:
Sent: Sunday, December 03, 2006 10:42 AM
Subject: Re: [sqlite] How do I speed up CREATE INDEX ?
On 12/2/06, Mohd Radzi Ibrahim <[EMAIL PROTECTED]> wrote:
- Original Message -
Because
- Original Message -
From: "Jay Sprenkle" <[EMAIL PROTECTED]>
To:
Sent: Sunday, December 03, 2006 9:12 AM
Subject: Re: [sqlite] How do I speed up CREATE INDEX ?
On 12/2/06, Mohd Radzi Ibrahim <[EMAIL PROTECTED]> wrote:
Hi,
I was loading a file to sqlite (3.3.
Hi,
I was loading a file to sqlite (3.3.8), and it took 4 mins to load 6 million
rows (with no index). But then when I run CREATE INDEX it took me 40 mins to do
that. What could I do to speed up the indexing process ?
Thanks.
Radzi.
Hi,
Could you tell me what breaks the transaction? Is create table/index within
transaction breaks it?
best regards,
Radzi.
- Original Message -
From: "Isaac Raway" <[EMAIL PROTECTED]>
To:
Sent: Thursday, October 19, 2006 2:07 AM
Subject: Re: [sqlite] sqlite performance questions.
Thanks, that works.
The syntax i used is allowed in MS SQL.
best regards,
Radzi.
- Original Message -
From: "Kees Nuyt" <[EMAIL PROTECTED]>
To:
Sent: Monday, October 16, 2006 1:54 PM
Subject: Re: [sqlite] How do i do this UPDATE in SQLite?
On Mon, 16 Oct 2006 09:53:19 +0800, you w
update i set val=qty*q.price
from salesrecord i
inner join historicalprice q on i.itemid=q.itemid
thanks.
Radzi.
Thank you guys for the suggestion. That's what I really need. Which one is
better, the sqlite3_interrupt() or sqlite3_progress_handler()? My gut
feeling is that sqlite3_interrupt() should be better since it does not
interfere with the running of the query until it is signaled. Besides, the
pro
Hi,
How do I cancel a long running query? In OLEDB I can call pICommand->Cancel()
from a different thread to kill the running query. How can I do the same in
SQLite?
thanks.
Radzi.
Thanks you It works fine now
Hello,
I m new to this mailing list ,
I currently try to add sql lite to a program I m working on
It is a quizz program ,
And I want the question to be incorporated into a sql lite database to enable
search ...etc..
I m download the source code of version 2_8_15
And compiled it under Vis
96 matches
Mail list logo