AtW - Info needed

[AtW]

Re: re

reynolds, just ignore compression for now ok? At the end of the day you may find that having behind the scenes transparent disk zip compressors is the best way forward. If you want to learn more about hand-optimising your data structures then read how they did it at Google.

[Vetran]

Re: re

MySQL Soundex

[AtW]

Re: re

> select M1.DocID
> from MainIndex M1,MainIndex M2
> where M1.KeyWordID=1
> and M2.KeyWordID=2
> and M1.DocID=M2.DocID

listen, I am probably in weird mood to want to supress guilt but this code belongs to PerlOfWisdom, I never bothered to reference table itself in the same join before I seen it.

phew, that was good - not feeling guilty anymore

[PerlOfWisdom]

Re: re

I never bothered to reference table itself in the same join before I seen it.

What does that mean?

[AtW]

Re: re

it means what it says - I rarely had to join same table, ie:

select * from
Table T1, Table T2
where T1.ID=T2.ID
and T1.Class=1
and T2.Class=2

I find that having to do that kind of query indicates poor architecture :hat

[PerlOfWisdom]

Re: re

Anyway, don't blame me. That was your code - entered before I entered anything.