Hi All,
I have created a sqlite database with create table EMP (F1 INTEGER ,F2
TEXT(1120) primary key collate nocase,F3 INTEGER ,LMD TEXT(1120) ,F4
TEXT(1120) ,F5 TEXT(1120));.
Here F2(Field2) is primary key. I used transaction queries for every
25,000 records. But performance issue is
Durga D durga.d...@... writes:
[...]
But performance issue is there.
Is there anyway to optimize this?
maybe you should try
PRAGMA journal_mode = OFF;
Oliver
___
sqlite-users mailing list
sqlite-users@sqlite.org
P Kishor wrote...
José,
Please note Igor's very important cautionary note below --
On Mon, Oct 11, 2010 at 7:05 AM, Igor Tandetnik itandet...@mvps.org
wrote:
P Kishor punk.k...@gmail.com wrote:
UPDATE OpenJobs
SET notes = 'string to add in front\r\n' || notes
WHERE spid = 32;
Note
Hi,
I saw this in the forum:
I've developped an SQLite extension including a very similar collation:
it sorts the (integral) prefix first and, in case of a draw, orders
based on the Unicode suffix.
It currently doesn't cope with floating-point prefixes but can surely
be adapted easily to do so.
-Message d'origine-
De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
boun...@sqlite.org] De la part de Clark Christensen
Envoyé : lundi, 11. octobre 2010 17:26
À : General Discussion of SQLite Database
Objet : Re: [sqlite] using SQLite with mod_perl
So, I want all the perl
Look in your mailbox.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hi Oliver,
Thank you for your prompt response.
I am using C++ wrappers in VC++ 8.0 applicaiton.
Where should I add PRAGMA?
And also when I insert 100k records by using statement,
m_oDB.execDML(strQuery);
virtual memory is keep on increasing. Any idea?
Durga.
On Tue, Oct 12, 2010
journal file is creating between transactions.
On Tue, Oct 12, 2010 at 3:00 PM, Oliver Peters oliver@web.de wrote:
Durga D durga.d...@... writes:
[...]
But performance issue is there.
Is there anyway to optimize this?
maybe you should try
PRAGMA journal_mode = OFF;
On Sat, Oct 9, 2010 at 11:28 AM, Jim Wilcoxson pri...@gmail.com wrote:
This may be a bug in 3.7.1, or I may have been taking advantage of a flaw
in
3.6.18:
HashBackup uses SQLite to store backup data in a meta data db and file data
archive db. First I open the main database, then attach an
Drake Wilson said:
- However, it now occurs to me that it may be possible to use the
- fts3_tokenizer() function in a trigger, which is probably a bad thing
- when writing to untrusted databases.
I suppose the only way to accomplish it would be to recompile sqlite3
with my custom tokenizer in
Michele,
Here is another thought for you to consider. Apparently your
application consistently generates some records, each record is marked
with a timestamp of its creation and after some time you have to
garbage-collect all records that are at least at a certain amount of
time in the past. You
Thank you for the advice, I'll try it in my application.
regards
Il 12/10/2010 17.17, Pavel Ivanov ha scritto:
Michele,
Here is another thought for you to consider. Apparently your
application consistently generates some records, each record is marked
with a timestamp of its creation and
Quoth Travis Orr t...@ivl.com, on 2010-10-12 08:17:38 -0700:
Drake Wilson said:
- However, it now occurs to me that it may be possible to use the
- fts3_tokenizer() function in a trigger, which is probably a bad thing
- when writing to untrusted databases.
I suppose the only way to
There are several GUI editors for SQLite, but is there one that allows
creation of simple forms to allow data entry. Although some allow
adding data to a single table, none that I have looked at seem to
allow a new record to be added when it involves more than one table.
It needs to be cross
Graham Smith myotis...@... writes:
There are several GUI editors for SQLite, but is there one that allows
creation of simple forms to allow data entry. Although some allow
adding data to a single table, none that I have looked at seem to
allow a new record to be added when it involves more
Oliver
OpenOffice Base
you need an ODBC driver too (http://www.ch-werner.de/sqliteodbc/)
Thanks, I did consider this, but the last time I tried, it was very
clunky, and crashed a lot, but I will have another look since you
have suggested it.
Graham
Graham Smith myotis...@... writes:
[...]
Thanks, I did consider this, but the last time I tried, it was very
clunky, and crashed a lot, but I will have another look since you
have suggested it.
[...]
works fine now but take the latest odbc driver from here:
Oliver
works fine now but take the latest odbc driver from here:
http://www.ch-werner.de/sqliteodbc/sqliteodbc-088pre2.exe
because the 0.87 has a problem under special circumstances (makros) -
something
you will use if you like to automate some functions in your forms or make them
more
ahh I forgot:
the best is to take OOo 330 m9
that is a milestone without all former illnesses - believe me I suffered a lot
D o n' t use 3.2.1!!!
Oliver
___
sqlite-users mailing list
sqlite-users@sqlite.org
I hope I'm not OT, if I am please forgive me!
I'm writing a Java application I use sqlite to save data on disk.
Everything works fine, I used sqlite successfully for months, with any
type of data but bytes.
I need to store and read from my sqlite database BLOB fields.
I created a table CREATE
Take a look at Kexi. (kexi-project.org) It is part of the Koffice suite, but
can be used standalone. I had tested it on Windows and had no trouble
installing it.
It uses sqlite as its back end storage and allows you to create forms, etc. Its
aim is to be like MS Access.
David
--- On Tue,
On 12 October 2010 17:51, Graham Smith myotis...@gmail.com wrote:
There are several GUI editors for SQLite, but is there one that allows
creation of simple forms to allow data entry. Although some allow
adding data to a single table, none that I have looked at seem to
allow a new record to be
the best is to take OOo 330 m9
that is a milestone without all former illnesses - believe me I suffered a lot
D o n' t use 3.2.1!!!
Mmmm, still stuck on 3.2.1 with current release of Ubuntu (the OS I
use most of the time, followed by my Mac), so interesting to hear your
views on 3.2.1.
David
Take a look at Kexi. (kexi-project.org) It is part of the Koffice suite, but
can be used standalone. I had tested it on Windows and had no trouble
installing it.
I have also used this before (on Ubuntu) as well as the OOo option, I
suppose I find the SQLite GUIs that much nimbler
Graham Smith myotis...@... writes:
[...]
Mmmm, still stuck on 3.2.1 with current release of Ubuntu (the OS I
use most of the time, followed by my Mac), so interesting to hear your
views on 3.2.1.
I use OOo under WinXP and had a problem related to 3.2.1 in connection with
UNIQUE CONSTRAINTS
Vivien,
Libgda: http://www.gnome-db.org
This is certainly a new one for me, I will give it a look.
Thanks,
Graham
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Oliver
I use OOo under WinXP and had a problem related to 3.2.1 in connection with
UNIQUE CONSTRAINTS
Not sure I understand everything in the thread, but worth knowing as I learn.
Thanks,
Graham
___
sqlite-users mailing list
sqlite-users@sqlite.org
On Mon, Oct 11, 2010 at 8:13 AM, Jay A. Kreibich j...@kreibi.ch wrote:
On Mon, Oct 11, 2010 at 02:08:54PM +0200, Michele Pradella scratched on the
wall:
Ok so the main idea it's always the same: split the DELETE to make the
operation on less records, but do it more often.
Another thought
On Tue, Oct 12, 2010 at 8:40 AM, Drake Wilson dr...@begriffli.ch wrote:
Just to clarify, a trigger isn't useful for this in general, because
you still have nowhere to get the function pointer from. Above I was
worrying that the current SQLite code might be less safe than it could
be as a
On 12 Oct 2010, at 6:30pm, Scott Hess wrote:
Something like:
INSERT INTO my_table VALUES (blah, blah, blah);
DELETE FROM my_table WHERE date_or_whatever some_limit LIMIT 5;
If your insert load consistently tracks from day to day, this mostly
looks like a circular buffer. The main
Quoth Scott Hess sh...@google.com, on 2010-10-12 10:33:54 -0700:
Since the tokenizer-registration code accepts an encoded pointer to a
vtable, it probably should be considered unsafe to expose to users.
For Gears and Chrome, where SQLite is exposed to web developers, we
did manual tokenizer
If I get it correctly, currently SQLite only supports REALS only as Double,
requiring 8 byte per number, which is for many applications quite expensive.
What are the chances to get Single support in a future release? What is the
appropriate way to propose such a feature?
I understand that there
I don't believe this!
Now I want to do a wrapper for Insert - by doing simple calls to:
loop this:
{
sqlite3_prepare_v2
sqlite3_bind_*
sqlite3_step
sqlite3_finalize
}
By my understanding this is what SQLite exec does - prepare, then
step, then finalize and it works.
The problem is - when I
On Tue, Oct 12, 2010 at 6:54 PM, Vincent Adam Burns discol...@gmail.comwrote:
Is there an active maintainer for the Lemon Parser? I'm getting some
parsing conflicts, ex:
statement ::= IF LEFT_PAREN expression RIGHT_PAREN statement ELSE
statement.
statement ::= IF LEFT_PAREN expression
Solved this myself so no help needed.
Apparently the problem was last parameter in sqlite3_prepare_v2 which
was pointing to unallocated memory after execution. As NULL is
allowed, I simply put it to NULL to ignore it which solved the whole
thing.
That kind of explains all the spooky behaviour as
35 matches
Mail list logo