• Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

AtW - Info needed

  • Thread starter Thread starter reynolds
  • Start date Start date
Re: re

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.
 
Re: re

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 :D
 
Re: re

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
 
Re: re

Re: re

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

Advertisers

Back
Top