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!
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.
> 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.