On 10 Oct 2011, at 12:37am, Frank Chang wrote:
> Simon Slavin, Here is the schema which I used. CREATE TABLE
> [BlobLastNameTest] ([FieldName] CHAR (25), [Vertices] BLOB )
Okay. That's not what you posted originally. Okay so we have
CREATE TABLE BlobLastNameTest (FieldName TEXT PRIMARY KEY,
Simon Slavin, Here is the schema which I used. CREATE TABLE [BlobLastNameTest]
([FieldName] CHAR (25), [Vertices] BLOB )
With this schema it is possible to have multiple rows with the same
FieldName. This is intentional since I am writing a Windows and Linux C++
multithreaded application
On 9 Oct 2011, at 4:13pm, Frank Chang wrote:
> CREATE TABLE [BlobLastNameTest] ([FieldName] CHAR (25) PRIMARY KEY,
> [Vertices] BLOB )
This form
CREATE TABLE BlobLastNameTest (FieldName TEXT PRIMARY KEY, Vertices BLOB)
does exactly the same in SQLite.
>
* Frank Chang:
> This table could potentially hold 10 to 40 million rows. We are
> using the following query to obtain the minumum rowid for each
> unique LastName:
>
> sqlite> explain query plan select t1.FieldName,t1.rowid from BlobLastNameTest
> t1
> GROUP BY t1.FIELDNAME HAVING t1.rowid =
Frank Chang wrote:
> Hi, We are using the following schema :
> CREATE TABLE [BlobLastNameTest] ([FieldName] CHAR (25) PRIMARY KEY,
> [Vertices] BLOB )
>
> index|sqlite_autoindex_BlobLastNameTest_1|BlobLastNameTest|3|
>
>
> This table could potentially hold 10 to 40
Hi, We are using the following schema :
CREATE TABLE [BlobLastNameTest] ([FieldName] CHAR (25) PRIMARY KEY, [Vertices]
BLOB )
index|sqlite_autoindex_BlobLastNameTest_1|BlobLastNameTest|3|
This table could potentially hold 10 to 40 million rows. We are using the
following query to obtain
6 matches
Mail list logo