Ok I hadn't toyed with those. Just tried it, the speed for queries
hasn't increased much, but a little
However, I started getting hard drive thrashes for 10+ seconds from
time to time. Will investigate the cahce further to see what suits
this app
> Did you try increasing the page cache size.
Did you try increasing the page cache size. Your data set is very big.
pragma page_cache = 2;
This should at least improve the speed for queries.
Clive
"Chris Schirlinger" <[EMAIL PROTECTED]> on 02-02-2005 09:07:49
Please respond to [EMAIL PROTECTED]
To: sqlite-users@sqlite.org
> What speed were you expecting?
> Are you comparing it to another database? If so what are the results for that
> database?
Anything better than what we got. The results are the worst we have
gotton from any DB or any self rolled data system (Jet is better, het
shouldn't be better)
After more
What speed were you expecting?
Are you comparing it to another database? If so what are the results for that
database?
Clive
"Chris Schirlinger" <[EMAIL PROTECTED]> on 02-02-2005 06:00:45
Please respond to [EMAIL PROTECTED]
To: sqlite-users@sqlite.org
cc:(bcc: clive/Emultek)
Eric,
No, you're not missing anything. I asked this same question about a
month ago. Dr. Hipp replied that argument substitution is not allowed
in those cases, because it's allowed only where any of the datatypes
allowed for substitution would be legal (blob, int, string, null). As
limit and
When I attempt to prepare the following statement using sqlite3_prepare:
SELECT id FROM testEntity LIMIT 5 OFFSET ?;
I get the following error back from SQLite:
near "?": syntax error
Is this really not allowed? If so, that seems a bit odd to me. This
seems like a classic use-case for
I've got a 6 million row DB in SQLite 3, but getting... odd results
which don't match up with the speed tests I've seen
The statement:
SELECT * FROM myTable WHERE myKey=1000
takes between 1 second to 4 or 5 on spikes. The returned result set
is ~2000 records. I havn't seen more than 2000
nope. that doesnt work either. i got no problem
outputing other recoard. but got problem with
strftime('%s', 'now')
--- Jeff Thompson <[EMAIL PROTECTED]> wrote:
> On Tue, 1 Feb 2005 06:51:49 -0800 (PST), teoh
> <[EMAIL PROTECTED]> wrote:
> >
> > sqlite3::reader reader=con.executereader("select
Hi..
We had a question regarding the lock data structures in the file
os_unix.c. The data structure is the lockInfo structure. The fields in
the lock info structure are
struct lockInfo {
struct lockKey key; /* The lookup key */
int cnt; /* Number of SHARED locks held */
int
* Griggs, Donald <[EMAIL PROTECTED]> [0246 18:46]:
>
> > -Original Message-
> > From: Dick Davies [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, February 01, 2005 3:52 PM
> > To: SQLite
> > Subject: [sqlite] foreign keys? (sqlite3)
> >
> >
> > The docs seem to say sqlite3 does'nt support
http://www.sqlite.org/faq.html#q7 states, "You should avoid putting SQLite
database files on NFS if multiple processes might try to access the file at the
same time."
Is that recomendation only intended for cases where one of the processes is a
"writer"?
Should I avoid the case where there
> create table each_transaction(datetime int);
> insert into each_transaction values( datetime('%s', 'now'));
Perhaps you should say
insert into each_transaction values( strftime('%s', 'now'));
?
http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
e
> this is how I create table
> -Original Message-
> From: Dick Davies [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, February 01, 2005 3:52 PM
> To: SQLite
> Subject: [sqlite] foreign keys? (sqlite3)
>
>
> The docs seem to say sqlite3 does'nt support foreign keys, is
> that correct?
>
> If so, I don't understand what
Did you try this?
create table each_transaction(datetime text);
insert into each_transaction(datetime) values(datetime('now'));
D:\temp\convention>sqlite3 test.db
SQLite version 3.0.8
Enter ".help" for instructions
sqlite> create table each_transaction(datetime text);
sqlite> insert into
Sqlite parser DOES parse foreign key constraints. Try this:
create table t1(
id integer,
id1 integer,
id2 integer,
id3 integer,
foreign key (id1,id2) references anotherTable(id,id1),
foreign key (id3) references somethingElse(id)
);
pragma foreign_key_list(t1);
However, this does not mean that
[EMAIL PROTECTED] said:
> I have run into problems trying to use SQLite via perl DBA.
> According to the SQLite.org web site, DECLARE CURSOR should be supported
> (actually, it is not in the list of the only SQL not supported).
> I get a error saying "error near DECLARE". I have tried to declare
>>yep, but again who cares, 99% of the world is on windows<<
He does. Since I have no idea what the requirements of this project
are, and he does, hopefully the points he wrote are relevant. If one
of the requirements for this project are that it run on BeOS on a 400
mhz processor with half a
On Tue, 1 Feb 2005 06:51:49 -0800 (PST), teoh <[EMAIL PROTECTED]> wrote:
>
> sqlite3::reader reader=con.executereader("select *
> from each_transaction;");
> while(reader.read())
> {cout << reader.getcolname(0) << ": " <<
> reader.getstring(0) << endl; }
>
> I get output like this:
>
>
nope. reader.getint32(0) will return 0
i tried changed datetime to "text" and did the query
by getsring(0) and i get same invalid output
output:
á "
i still cant use strftime('%s', 'now') .
--- [EMAIL PROTECTED] wrote:
> teoh <[EMAIL PROTECTED]> writes:
>
> > create table
teoh <[EMAIL PROTECTED]> writes:
> create table each_transaction(datetime int);
>
> insert into each_transaction values( datetime('%s',
> 'now'));
>
> this is how I create table and insert the
> strftime('%s', 'now'). But when I did query with
> sql3_plus.
>
> sqlite3::reader
what i trying to say is, i cant use strftime('%s',
'now') but also to use other function like
datetime('now') . This is because the output of select
will be invalid. if i use datetime('now') . the output
is 2005-02-01 15:44:23 . How does the "select"
statement should look like if i want it to
Hi !
An interesting enchantment may be (if anyone development that) an
"VACUUM INFILE" method.
That is (when many pages are unuseable (free) in db) a "pragma signed"
transaction.
If flag is -1, the db engine is use the last, and nearly to last pages.
When flag is 1, the engine is use first, and
Does this fix it?
insert into each_transaction(datetime) values(datetime('now'));
--- teoh <[EMAIL PROTECTED]> wrote:
>
> create table each_transaction(datetime int);
>
> insert into each_transaction values( datetime('%s',
> 'now'));
>
> this is how I create table and insert the
>
create table each_transaction(datetime int);
insert into each_transaction values( datetime('%s',
'now'));
this is how I create table and insert the
strftime('%s', 'now'). But when I did query with
sql3_plus.
sqlite3::reader reader=con.executereader("select *
from each_transaction;");
Version 3.1 supports "pragma auto_vacuum" as an alternative.
3.1 is currently still in alpha stage though.
http://www.sqlite.org/pragma.html#modify
--- [EMAIL PROTECTED] wrote:
>
>
>
> Thanks.
> I am not sure this is very useful, because it copies the database, which
> requires that
Hello list!
I have run into problems trying to use SQLite via perl DBA.
According to the SQLite.org web site, DECLARE CURSOR should be supported
(actually, it is not in the list of the only SQL not supported).
I get a error saying "error near DECLARE". I have tried to declare cursor
in many
The docs seem to say sqlite3 does'nt support foreign keys,
is that correct?
If so, I don't understand what
---8<
#
PRAGMA foreign_key_list(table-name);
For each foreign key that references a column in the argument table,
Thanks.
I am not sure this is very useful, because it copies the database, which
requires that there be enough file space for a copy.
It would be nice if there was something that worked by truncating the file.
Clive
Dick Davies <[EMAIL PROTECTED]> on 01-02-2005 13:40:13
Please respond to
* [EMAIL PROTECTED] <[EMAIL PROTECTED]> [0212 11:12]:
>
>
>
> Is there a way to compact a database after removing data?
vacuum ?
--
'One cannot make an omelette without breaking eggs --
but it is amazing
how many eggs one can break without making a decent omelette.'
--
Is there a way to compact a database after removing data?
Clive
--- "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> Hi !
>
> My question is that: I use hungarian (win1250, iso-8859-2) character
> set, what containing special accented characters:
> a' - á
> e' - é
>
> and etc.
>
> I want to sort my sql by this collation order.
> But I cannot do that,
Hi !
My question is that: I use hungarian (win1250, iso-8859-2) character
set, what containing special accented characters:
a' - á
e' - é
and etc.
I want to sort my sql by this collation order.
But I cannot do that, only with outer programme (I use Delphi wrapper
library).
1. Can I do that
>Not true at all. In fact, from experience, the Linux OS is
>>much more full of holes than Windows. It appears most hate
>>
>>
Linux OS is the kernel, the rest is third party. The kernel 2.6.10 is
now the latest, that means there were 10 upgrades last three (four ?) years in
the serie
Hi,
> > 10. SQLite runs on almost ever operating systems. SQL Server runs
> > on MS Windows exclusively.
> >
> yep, but again who cares, 99% of the world is on windows
This is probably true for desktops, but not for servers.
And a lot of people cares.
> > 13. Open source and Free Software such
34 matches
Mail list logo