Tito Ciuro wrote:
Due to application requirements, I must rely on LIKE and GLOB in
order to match data, matching data that contains some value
(sensitive or insensitive match).
Now, it seems to me that using either LIKE or GLOB will force a row
scan anyhow, since it can't use the
Hi Denis,
I've been reading your email carefully and I'd like to comment it.
On 28/03/2006, at 14:24, Dennis Cote wrote:
With these tables you will have 25K rows in the File table, one per
file, and 250K rows in the Attribute table assuming an average of
10 attributes per file (your
Tito,
I am replying off list because I don't want to contribute to turning
this thread into a flame war...
You have shown wonderful patience and politeness on this list. You
have my gratitude and respect for this.
Regards,
e
Tuesday, March 28, 2006, 5:35:37 PM, Tito Ciuro wrote:
> Hi Dennis,
ch 28, 2006 4:24 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] [SOLVED] Re: [sqlite] LIKE and GLOB bug with
> numbers?
>
>
> Tito Ciuro wrote:
>
> >
> > I have no idea why you're so angry. Anyway, there are so
...
> While the tone of MGC's post may have been a
Tito Ciuro wrote:
I have no idea why you're so angry. Anyway, there are so many things
I can think of saying, I'll just make it brief and to the point.
This thing won't scale. I'd like to see it when you have the 4.5
million records my database contains,
and that is still tiny for all
John,
Did you read my replies at all? If not, please take 15 seconds to do
so. I thanked *all of you* in all three emails.
Just in case, if that wasn't enough, allow me to do that for the
fourth time: I most sincerely appreciate the time and effort that you
guys have taken to answer my
Tito,
Several people have bothered to spend the time and effort to give you
some well considered help. That is what forums like this are for,
professional guidance and development. Thank them.
Tito Ciuro wrote:
MGC,
I have no idea why you're so angry. Anyway, there are so many things I
MGC,
I have no idea why you're so angry. Anyway, there are so many things
I can think of saying, I'll just make it brief and to the point.
1) Regarding your statement:
This thing won't scale. I'd like to see it when you have the 4.5
million records my database contains,
and that is still
Tito Ciuro wrote:
Oh!... just a quick message for the row-scan non-believers out there:
SQLite flies, even under this scenario. I'm getting wonderful
performance numbers by keeping everything within SQLite-land. The
code is simple and I let SQLite do all the magic. What else can I ask
ROTECTED]>
To: "Forum SQLite" <sqlite-users@sqlite.org>
Sent: Sunday, March 26, 2006 6:50 PM
Subject: [sqlite] LIKE and GLOB bug with numbers?
Hello,
I've populated a datafile with 40.176 records which contain file
attributes and file paths. I have two columns, CMKey a
nal Message -
From: "Tito Ciuro" <[EMAIL PROTECTED]>
To: "Forum SQLite" <sqlite-users@sqlite.org>
Sent: Sunday, March 26, 2006 6:50 PM
Subject: [sqlite] LIKE and GLOB bug with numbers?
Hello,
I've populated a datafile with 40.176 records which cont
Hello everybody,
On 26/03/2006, at 10:08, John Stanton wrote:
LIKE and GLOB do a row scan, and give you none of the advantages of
an RDBMS. Why not use a flat file and grep and get simplicity and
greater speed?
I'm very well aware that LIKE and GLOB perform a row scan. I do
appreciate
John Stanton wrote:
Tito Ciuro wrote:
On 26/03/2006, at 10:51, MGC wrote:
Your design is fundamentaly wrong.
I don't know what your intended use
is for this data, but I am logging identical fstat file info along
with an
MD5 sums.
Well... if you don't know what is the intended use for
Tito Ciuro wrote:
On 26/03/2006, at 10:51, MGC wrote:
Your design is fundamentaly wrong.
I don't know what your intended use
is for this data, but I am logging identical fstat file info along
with an
MD5 sums.
Well... if you don't know what is the intended use for the data, how
can you
On 26/03/2006, at 10:51, MGC wrote:
Your design is fundamentaly wrong.
I don't know what your intended use
is for this data, but I am logging identical fstat file info along
with an
MD5 sums.
Well... if you don't know what is the intended use for the data, how
can you say that my design
There may be an issue, but.
Your design is fundamentaly wrong.
I don't know what your intended use
is for this data, but I am logging identical fstat file info along with an
MD5 sums.
Each informational element needs
to be stored in an individual column.
Stuffing all those fields into a
Hello,
I've populated a datafile with 40.176 records which contain file
attributes and file paths. I have two columns, CMKey and CMValues.
The column CMKey contains the path to the file and the column
CMValues contains the attribute values. For example:
CMKey: Application
17 matches
Mail list logo