Hi
Q1. Need to know if there is maximum limit for record size ?
Q2. What are the consequence of using such large record size ? I may need
large record size in two-three tables.
In two or three of my tables, I may need to have 64 columns or more and
maximum record size may reach to approx. 2
Trevor Talbot wrote:
Michael is referring to a direct map from disk pages to memory pages
(OS notion of pages, not sqlite's), using something like mmap() on
unix or MapViewOfFile() on Windows. This way memory is directly
backed by the file it refers to, instead of copying the data to
entirely
Michael is referring to a direct map from disk pages to memory pages
(OS notion of pages, not sqlite's), using something like mmap() on
unix or MapViewOfFile() on Windows. This way memory is directly
backed by the file it refers to, instead of copying the data to
entirely new pages (possibly
On Thu, 28 Sep 2006, Griggs, Donald wrote:
Depending on your needs, if it's awkward to trim away the final delimiter,
you might choose to simply add a dummy field to your table.
Donald,
No, it's easy enough in joe to replace a space followed by the end-of-line
($) with just the
Regarding Rich Shepard's problem:
"...tells me that 31 columns are expected, but it found 32."
And tagging onto Dennis Cote's explanation:
"...I suspect you may have trailing spaces at the ends of your lines."
I agree with Dennis.
Apparently there are different interpretations for
On Thu, 28 Sep 2006, Dennis Cote wrote:
I suspect you may have trailing spaces at the ends of your lines. The
.import command isn't very smart about things like that. Your separator is
set to one space, not arbitrary whitespace. It there is another separator
after the last field it assumes
Ron Stevens wrote:
The problem is that I can't produce a canonical representation of the
entries in my database. Often times some entries are subsets of
others, but considered equal. It's possible for an entry to be a
subset of two larger entries that aren't equal themselves and still
be equal
I'm using the sqlite3 dll with the Finisar.SQLite.NET wrapper in our
application written in C#. Currently I'm using version 3.3.7, but I have
been having the problem going back to version 3.3.4 which is when we
started using SQLite. Most of the time everything works fine, but every
once in a blue
Rich Shepard wrote:
When I try to import a data file into an existing table, sqlite's shell
tells me that 31 columns are expected, but it found 32. Now I no
longer have
the visual acuity I did when I was a teenager, but no matter how many
times
I count the fields, they total 31. Therefore, I
The problem is that I can't produce a canonical representation of the
entries in my database. Often times some entries are subsets of others, but
considered equal. It's possible for an entry to be a subset of two larger
entries that aren't equal themselves and still be equal to each of the
larger
When I try to import a data file into an existing table, sqlite's shell
tells me that 31 columns are expected, but it found 32. Now I no longer have
the visual acuity I did when I was a teenager, but no matter how many times
I count the fields, they total 31. Therefore, I don't know why I'm
Hello,
i wish to insert data in a table from a Tcl program
i use this command:
"db1 copy ignore mvt sbple92.txt |"
no data is inserted and
"db1 errorcode"
returns 0
the file is ok (number of columns..), if i use sqlite3.exe and ".import
sbple92.txt mvt"
the data is inserted
Sqlite 3.3.7
Tcl/Tk
Le Thu, 28 Sep 2006 19:36:34 +0200,
Kees Nuyt <[EMAIL PROTECTED]> a écrit :
> BTW, I wonder why do you ask? It is much faster to test that
> yourself than ask someone else
Of Course I had made some tests but I wanted to be sure to have all
available information In order to be able to handle
Ron Stevens wrote:
I have a custom function that compares two text values and returns 1
if they're equal based on an algorithm that's not strictly text
comparison and 0 if they don't match. I want to do a query that
groups all rows that match using my custom function into a single
group. Is
I have a custom function that compares two text values and returns 1 if
they're equal based on an algorithm that's not strictly text comparison and
0 if they don't match. I want to do a query that groups all rows that match
using my custom function into a single group. Is that possible?
On Thu, 28 Sep 2006 15:45:54 +0200, you wrote:
Hi Michael
>-Ursprüngliche Nachricht-
>Von: Jay Sprenkle [mailto:[EMAIL PROTECTED]
>Gesendet: Donnerstag, 28. September 2006 15:37
>An: sqlite-users@sqlite.org
>Betreff: Re: [sqlite] Memory mapped db
>That's not really the same. I would
On Thu, 28 Sep 2006 15:32:03 +0200, you wrote:
>
>Has anyone tested an sqlite which memory-maps the db-file into ram? Is this
>an old (maybe bad idea :-) ? I've looked over the source and it seems that
>read and write operations are used through a singled interface, so it maybe
>possible to
On 9/27/06, James W. Walker <[EMAIL PROTECTED]> wrote:
What is the fastest way to change the values in one column in every
row? What I thought of was like so:
BEGIN TRANSACTION;
UPDATE MyTable SET TheCol=7 WHERE keyCol=1;
UPDATE MyTable SET TheCol=8 WHERE keyCol=2;
... and so on for
Dennis Cote a écrit :
Noel Frankinet wrote:
I would like to create a user function to know if a record is
contained in a rectangle ?
If have looked to sqlite_create_function
I know that my record has for column (xmin,ymin,xmax,ymax)
I would like to use the new function to write something
On Thu, 28 Sep 2006 09:35:54 +0200, you wrote:
> Le Thu, 28 Sep 2006 00:01:08 +0200,
> Kees Nuyt <[EMAIL PROTECTED]> a écrit :
>
>> The first 15 bytes of the sqlite database file tell you which
>> file format it is. The file format doesn't change that often, so
>> it can be compatible with
Ran <[EMAIL PROTECTED]> wrote:
>
> I thought to solve this by attaching another database I will create
> temporarily for each query, and to place the temporary tables in this
> attached temporary database. This way, *I think*, my main database will be
> locked shared (I will only select from it)
Hi all,
I am not sure of the way attached database behaves in respect to locks and
could not find an answer in the documentation about it.
I have a very complex query which I simplify by using temporary tables.
However, this means that every time this complex query is executed, the
database is
Noel Frankinet wrote:
I would like to create a user function to know if a record is
contained in a rectangle ?
If have looked to sqlite_create_function
I know that my record has for column (xmin,ymin,xmax,ymax)
I would like to use the new function to write something like
select * from table
Chris Gurtler <[EMAIL PROTECTED]> wrote:
Is it possible to do multiple updates of blobs using the bind
variables, I was doing them 1 at a time but it was a little slow.
For example :-
rc = sqlite3_prepare(objects_db, "UPDATE table SET proprietary_data =
? WHERE device_id = ? and instance = ?",
Noel Frankinet <[EMAIL PROTECTED]> wrote:
I would like to create a user function to know if a record is
contained in a rectangle ?
If have looked to sqlite_create_function
I know that my record has for column (xmin,ymin,xmax,ymax)
I would like to use the new function to write something like
Michael Wohlwend wrote:
Has anyone tested an sqlite which memory-maps the db-file into ram? Is this
an old (maybe bad idea :-) ? I've looked over the source and it seems that
read and write operations are used through a singled interface, so it maybe
possible to implement it without too much
-Ursprüngliche Nachricht-
Von: Jay Sprenkle [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 28. September 2006 15:37
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Memory mapped db
>use the database named:memory:
>for a ram database. In a lot of cases it will be cached by
>the
use the database named:memory:
for a ram database. In a lot of cases it will be cached by
the operating system so it ends up being that way anyway!
On 9/28/06, Michael Wohlwend <[EMAIL PROTECTED]> wrote:
Has anyone tested an sqlite which memory-maps the db-file into ram? Is this
an old
Has anyone tested an sqlite which memory-maps the db-file into ram? Is this
an old (maybe bad idea :-) ? I've looked over the source and it seems that
read and write operations are used through a singled interface, so it maybe
possible to implement it without too much trouble...
Any comments
On 9/28/06, Chris Gurtler <[EMAIL PROTECTED]> wrote:
I wish I could use transactions, but because I'm updating a blob I need
to do it that way. Ill check out the PRAGMA option to see if that helps.
Why does what you showed above mean you can't use transactions?
Also, that PRAGMA will mean a
Thanks,
I wish I could use transactions, but because I'm updating a blob I need
to do it that way. Ill check out the PRAGMA option to see if that helps.
Regards,
Chris
He Shiming wrote:
Hi All,
Is it possible to do multiple updates of blobs using the bind
variables, I was doing them 1
Hi All,
Is it possible to do multiple updates of blobs using the bind variables, I
was doing them 1 at a time but it was a little slow.
For example :-
rc = sqlite3_prepare(objects_db, "UPDATE table SET proprietary_data = ?
WHERE device_id = ? and instance = ?", -1, , 0);
for (i= 0; i
-Ursprüngliche Nachricht-
Von: Martin Pfeifle [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 26. September 2006 13:35
An: sqlite-users@sqlite.org
Betreff: AW: AW: [sqlite] Performance question
>Hi Michael,
>could you please (re)post the exact create inex statements +primary key you
Le Thu, 28 Sep 2006 00:01:08 +0200,
Kees Nuyt <[EMAIL PROTECTED]> a écrit :
> The first 15 bytes of the sqlite database file tell you which
> file format it is. The file format doesn't change that often, so
> it can be compatible with several software versions.
Thanks for your answer. Do you
34 matches
Mail list logo