On Sep 22, 2008, at 12:37 PM, Dave Dyer wrote:
>
>>
>> Yes, I've noticed and reported this same problem. It appears that the
>> SQLite bundled in Mac OS X has a special flag set to allow opening
>> database files on networked volume, and that works great.
>
>
> So what's the name of this special
>
>Yes, I've noticed and reported this same problem. It appears that the
>SQLite bundled in Mac OS X has a special flag set to allow opening
>database files on networked volume, and that works great.
So what's the name of this special flag?
___
"jason weaver" <[EMAIL PROTECTED]> wrote
in message
news:[EMAIL PROTECTED]
> However, due to database locking issues, I need to do a bunch of
> inserts in one transaction or batch. Thus, I store them in a simple
> queue. Therefore, the julianday('now') won't work because all of my
> batch inserts
I've searched and searched but haven't found anything that really answers
this question. If I've missed something, please point me in the right
direction.
I want to put the "right" type of timestamp in my dbase. According to my
research, the "right" type is like this:
- create table my_table(date
Hi Dave,
> I'm experimenting with using networked files as sqlite databases
> (yes, I'm aware this is a questionable practice)
It seems quite valid for remote access to make ad hoc small changes to
large hosted database files, or to provide shared access to small user
databases files via de
> IS it possible to get on a daily digest list so that it is not
> clogging my e-box with the individual e-mails?
> I know of several other group that have that option
>
> Chris
>
> Design simplicity eliminates engineering complexity.
Hi Chris,
The design simplicity of this mail list eliminate
>> I was using count(*) just to detect the presence of any record
>> meeting given condition. Is it possible to make
>> it fast _not_ using count(*)? I need just a "boolean result" of 1/0
>> (yes, there is at least one / there aren't any).
>>
> Add limit 1 to the query, so that it sto
On 9/21/08, chris newgent <[EMAIL PROTECTED]> wrote:
> IS it possible to get on a daily digest list so that it is not clogging my
> e-box with the individual e-mails?
> I know of several other group that have that option
>
> Chris
>
> Design simplicity eliminates engineering complexity.
>
>
>
>
IS it possible to get on a daily digest list so that it is not clogging my
e-box with the individual e-mails?
I know of several other group that have that option
Chris
Design simplicity eliminates engineering complexity.
___
sqlite-users maili
Zbigniew Baniewski wrote:
> On Sun, Sep 21, 2008 at 05:22:46PM -0500, Jay A. Kreibich wrote:
>
>
>> count(*) is an odd one... In most database systems it is extremely
>> fast, but in SQLite it tends to be rather slow.
>>
>
> I forgot the important thing: usually I was using count(*) ju
On Mon, Sep 22, 2008 at 01:13:30AM +0200, Zbigniew Baniewski scratched on the
wall:
> On Sun, Sep 21, 2008 at 05:22:46PM -0500, Jay A. Kreibich wrote:
>
> > count(*) is an odd one... In most database systems it is extremely
> > fast, but in SQLite it tends to be rather slow.
> > [..]
> >
Hi everybody!
This is my first post in this list! I am very newbie with Sqlite. This is
the first time I am trying to use it. I am using Sqlite3 trough C interface.
The problem I have is this: I have a table created, just like this:
CREATE TABLE materia(
codigo INTEGER PRIMARY KEY,
nombre
"D. Richard Hipp" <[EMAIL PROTECTED]> wrote
in message news:[EMAIL PROTECTED]
> On Sep 21, 2008, at 8:51 AM, Russ Leighton wrote:
>
>> I am interested in ... a way
>> to constraint/control index selection on queries.
>>
>
> What other SQL database engines have this capability and what syntax
> do t
"Zbigniew Baniewski" <[EMAIL PROTECTED]> wrote
in message news:[EMAIL PROTECTED]
> The problem is, that it's not only about global number of records - I
> would to have a possibility to quickly count number of records found
> by conditional queries like: "select count(*) from table where
> ". Parti
On Sun, Sep 21, 2008 at 05:22:46PM -0500, Jay A. Kreibich wrote:
> count(*) is an odd one... In most database systems it is extremely
> fast, but in SQLite it tends to be rather slow.
I forgot the important thing: usually I was using count(*) just to detect
the presence of any record meeting
On Sun, Sep 21, 2008 at 05:22:46PM -0500, Jay A. Kreibich wrote:
> count(*) is an odd one... In most database systems it is extremely
> fast, but in SQLite it tends to be rather slow.
> [..]
> If you search the archives, you'll find many discussions on the best
> way to create a system
On Sun, Sep 21, 2008 at 11:32:18PM +0200, Zbigniew Baniewski scratched on the
wall:
> I've created a test database with almost one million records (about 20 fields
> each). I noticed, that the simple query like "select count(*) from table"
> takes about 10 seconds (the database file is of about 30
I've created a test database with almost one million records (about 20 fields
each). I noticed, that the simple query like "select count(*) from table"
takes about 10 seconds (the database file is of about 300 MB size).
I'm wondering: is it the limit - or is it still possible to reduce the
respons
Personally, I like the Mysql syntax best of the below links. Seems
natural and unobtrusive (unlike 'hints').
On Sep 21, 2008, at 12:12 PM, Alex Scotti wrote:
> not surprisingly, the db2 approach is the only one that seems to
> follow the "ideal" of the relational dbms. looks like you get to
>
not surprisingly, the db2 approach is the only one that seems to
follow the "ideal" of the relational dbms. looks like you get to
provide to the engine information about your data, rather than
describing to the engine what steps it's supposed to take. hints
that directly influence query p
A reason I think such functionality would be ideal for sqlite is that
it avoids the need for a fancy query plan optimizer. The user would
have a way to direct the query plan if the simple and obvious plan is
suboptimal.
On Sep 21, 2008, at 11:36 AM, "D. Richard Hipp" <[EMAIL PROTECTED]> wr
D. Richard Hipp wrote:
> On Sep 21, 2008, at 8:51 AM, Russ Leighton wrote:
>
>> I am interested in ... a way
>> to constraint/control index selection on queries.
>>
>
> What other SQL database engines have this capability and what syntax
> do they use?
Richard,
Hope this are useful:
Oracle:
Oracle has 'hints' which live in the comments emdedded in the select.
Google 'oracle hint use index'. The 3rd hit down my result list has a
nice overview.(I'd send the link but this stupid iPhone has no cut-n-
paste). I think that hints are really ugly. Not sure about the other
big dmbs.
On Sep 21, 2008, at 8:51 AM, Russ Leighton wrote:
> I am interested in ... a way
> to constraint/control index selection on queries.
>
What other SQL database engines have this capability and what syntax
do they use?
D. Richard Hipp
[EMAIL PROTECTED]
__
In a message dated 9/21/08 4:21:44 AM, [EMAIL PROTECTED] writes:
> (I'm sorry. I saw this and I just couldn't resist. I deserve everything you
> throw at me, but this is even better than the Windows Cache Manager bashing
> a few days ago.)
>
Doesn't the Windows Cash Manager list the prices?
-
On Sep 19, 2008, at 6:30 PM, D. Richard Hipp wrote:
>
> On Sep 19, 2008, at 5:47 PM, Russ Leighton wrote:
>
>>
>> Observation 1: Group by (in my case) is faster w/out using the index
>> than with using the index by 10X
>>
>> In my app I have a table-
>>
>> create table foo(k1integer ,k2 integer,
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:sqlite-users-
> [EMAIL PROTECTED] On Behalf Of Arvind M
> Sent: Sunday, September 21, 2008 3:30 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] prices
>
> dear sir
>
> i am interested in purchase of licence of sqlite server
>
>
Arvind M wrote:
> dear sir
>
> i am interested in purchase of licence of sqlite server
>
SQLite does not have a server-client architecture now, any more than it
did five months ago.
It is all-in-one. You can get the source code and write a server-client
pair yourself that uses the same
dear sir
i am interested in purchase of licence of sqlite server
kindly send me the detail
arvind
systime
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
29 matches
Mail list logo