Hi,
I think I found a bug in sqlite version 3.3.7. The steps to reproduce it is
as follows. I've tested it on Windows only.
C:\Something>sqlite3 newdb.db
CREATE TABLE 'MYTABLE' ('ID' INTEGER PRIMARY KEY);
INSERT INTO 'MYTABLE' ('ID') VALUES(1);
INSERT INTO 'MYTABLE' ('ID') VALUES(2);
INSERT
Hi all,
which one has the better performance between "GROUP BY" and "DISTINCT"?
I need to retrieve a distinct value of a specific column. Either "GROUP BY"
and "DISTINCT" could be finish that.
But I want to know which one has the better performance. Or I can use
another sql command to finish
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 like a liner
Hello,
Thanks for the explaination. Looks like
this isn't going to help me after all.
Thought sqlite3_exec() would compile the
query only once.
Best regards,
Kervin
--- Dennis Cote <[EMAIL PROTECTED]> wrote:
> Kervin L. Pierre wrote:
> > and for performance, I would like to execute as
> > few
Hello,
Thanks.
Best regards,
Kervin
--- [EMAIL PROTECTED] wrote:
> "Kervin L. Pierre" <[EMAIL PROTECTED]> wrote:
> > what is the maximumm number
> > of characters there can be in a query
> > string sent to sqlite_exec()?
>
> 2147483647 bytes
>
> --
> D. Richard Hipp <[EMAIL PROTECTED]>
>
Kervin L. Pierre wrote:
and for performance, I would like to execute as
few sqlite_exec() calls as possible.
Kervin,
While you can pass several SQL statements to sqlite3_exec in one sql
string, each statement is compiled and executed separately, so the
performance increase over separate
Da Martian wrote:
I cannot tell if sqlite uses my indeces or not. Is there a way
to tell what indexes are used in a query ?
Use the explain query plan command. Simply add these keywords before
your query.
EXPLAIN QUERY PLAN SELECT
Instead on the query results you will get a
On Mon, 18 Sep 2006 10:20:36 -0400, you wrote:
>There's no right or wrong way.
There is viewpoint from June 2006 with title:
"To BLOB or Not To BLOB:
Large Object Storage in a Database or a Filesystem?"
at
Hello Dennis,
Monday, September 18, 2006, 11:50:03 AM, you wrote:
DJ> Jay Sprenkle wrote:
>> On 9/18/06, Teg <[EMAIL PROTECTED]> wrote:
>>> Hello Jay,
DJ> Everyone has different needs. We like keeping all of the data (blobs
DJ> included) in one data file. We also use the encryption extension,
Jay Sprenkle wrote:
On 9/18/06, Teg <[EMAIL PROTECTED]> wrote:
Hello Jay,
The whole reason I store files in the DB in the first place is to have
a single "package" to move around and backup when needed. My
application is storing whole series of PNG and JPG files in the
DB with meta data
On 9/18/06, Teg <[EMAIL PROTECTED]> wrote:
Hello Jay,
There's no right or wrong way. I was just suggesting that there are
cases where you want to store the whole file in the DB. I have an
application that generates 1000's of 150K compressed files. I've been
toying with the idea of shoving them
Hello Jay,
Monday, September 18, 2006, 10:05:19 AM, you wrote:
JS> On 9/18/06, Teg <[EMAIL PROTECTED]> wrote:
>> Hello Jay,
>>
>> The whole reason I store files in the DB in the first place is to have
>> a single "package" to move around and backup when needed. My
>> application is storing whole
Thank you very much just i need confirmation on this..
If you don't mind could you please tell me if i want to perform that kind of
operation Is there any way other than storing in some temp file and
reading.using normal fopen() calls.
Please do needful
Thanks a lot
Sandhya R
-
On 9/18/06, Richard Stern <[EMAIL PROTECTED]> wrote:
I have a big table and I want to change all the values in a row to the same
thing but I'm not sure what key word would allow me to do this.
Nothing built into the SQL language.
it would be something like this:
update mytable
set column1 =
On 9/18/06, Teg <[EMAIL PROTECTED]> wrote:
Hello Jay,
The whole reason I store files in the DB in the first place is to have
a single "package" to move around and backup when needed. My
application is storing whole series of PNG and JPG files in the
DB with meta data describing where the images
SQLite does not (at this time) have the ability to incrementally
read or write BLOBs. You have to read and write the whole blob
all at once.
--
D. Richard Hipp <[EMAIL PROTECTED]>
-
To unsubscribe, send email to
I have a big table and I want to change all the values in a row to the same
thing but I'm not sure what key word would allow me to do this.
I tried things like:
INSERT INTO Table ALL VALUES ("test");
But it has an error on the ALL. I tried putting the ALL in lots of different
places but it
Hello Jay,
Monday, September 18, 2006, 9:23:27 AM, you wrote:
JS> On 9/18/06, sandhya <[EMAIL PROTECTED]> wrote:
>> I think too, if they are Big-Blobs, it is better to store only a Reference
>> to a File.
>>
>> May i know litlle more clearly about this?What it mean actually?
JS> Store the path
On 9/18/06, sandhya <[EMAIL PROTECTED]> wrote:
I think too, if they are Big-Blobs, it is better to store only a Reference
to a File.
May i know litlle more clearly about this?What it mean actually?
Store the path to the file in the database ( C:\somefile.dat or
/tmp/somefile.dat ).
Then
You mean,
I have to get the entire BLOB from the DB and has to store it in some
temp file and reading it?
Is there no way we can read the required no.of bytes of the data from the
DB directly and setting the pointer or handle to the current position?
Please tell me whether the way i am
Martin Alfredsson wrote:
> Reading the documentation is a bit contradicting:
>
> >A good rule of thumb is that you should avoid using SQLite in
> situations where
> >the same database will be accessed simultaneously from many computers
> over a network filesystem.
>
> >Most SQL database
TiNo <[EMAIL PROTECTED]> wrote:
> example:
>
> sqlite> select datetime('now');
> 2006-09-18 10:11:48
> sqlite> select datetime('now','utc');
> 2006-09-18 08:11:52
> sqlite> select datetime('now','localtime');
> 2006-09-18 12:11:58
>
>
> select datetime('now') shows utc time, Localtime shows my
On 9/17/06, Martin Alfredsson <[EMAIL PROTECTED]> wrote:
Reading the documentation is a bit contradicting:
>A good rule of thumb is that you should avoid using SQLite in
situations where
>the same database will be accessed simultaneously from many computers
over a network filesystem.
The
On 9/18/06, TiNo <[EMAIL PROTECTED]> wrote:
example:
sqlite> select datetime('now');
2006-09-18 10:11:48
sqlite> select datetime('now','utc');
2006-09-18 08:11:52
sqlite> select datetime('now','localtime');
2006-09-18 12:11:58
select datetime('now') shows utc time, Localtime shows my
example:
sqlite> select datetime('now');
2006-09-18 10:11:48
sqlite> select datetime('now','utc');
2006-09-18 08:11:52
sqlite> select datetime('now','localtime');
2006-09-18 12:11:58
select datetime('now') shows utc time, Localtime shows my localtime,
but now,utc is off. It should be the same
I think too, if they are Big-Blobs, it is better to store only a Reference
to a File.
May i know litlle more clearly about this?What it mean actually?
Right now what i am doing is, I have a directory in which somany files are
there and i have loaded all the files into database and the data(ie
I think too, if they are Big-Blobs, it is better to store only a Reference
to a File.
May i know litlle more clearly about this?What it mean actually?
Right now what i am doing is, I have a directory in which somany files are
there and i have loaded all the files into database and the data(ie
Hello
sandhya wrote:
> Hi,
> Is there any way of reading Blob data for the given no.of bytes?
> I mean is there any lseek kind of function call in sqlite to handle
> reading BLOB data.
http://www.sqlite.org/capi3ref.html says:
"If the result is a BLOB then the sqlite3_column_bytes() routine
28 matches
Mail list logo
