Re: Optimising a very large table

2010-02-20 Thread walter harms
Nathan Harmston schrieb: > Hi everyone, > > I am currently working on an application where I have a very large > table called intervals ( atm its 80 000 000 records and growing ), and > a smaller table ( token ) which join with it. > > interval is just an id, start, end, word > token is id, int

Optimising a very large table

2010-02-19 Thread Nathan Harmston
Hi everyone, I am currently working on an application where I have a very large table called intervals ( atm its 80 000 000 records and growing ), and a smaller table ( token ) which join with it. interval is just an id, start, end, word token is id, interval_id, type, processed_by There is a ma