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 index,
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 example
No problem. Your approach is a bit non-standard, but I'm glad you got it
working. It would be interesting to try what the others on the list are
suggesting (splitting your data into multiple columns, so that the db can
index them rather than forcing a full string search for every query) to see
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,
, 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 h
Hi Dennis,
On 28/03/2006, at 14:24, Dennis Cote wrote:
If you give this a try, you might be surprised at how flexible it is.
That was a very clear explanation. I will sure give it a try when I
have a chance.
Just because something works doesn't mean that it can't be improved.
I couldn'
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 in
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 em
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
11 matches
Mail list logo