> > > I got simple question I think. > > > I plan to have 5000-10000 article records. > > > I wonder what is faster: > > > store every article within one topic and filter > > > with one field or store it within many subtopics? > > > I guess every querry will force check every article > > > in article table. > >
I gor two ways of making this. 1. Create two topics tree. First of them keeps articles wchich will be very often deleted and inserted but will get always the same name, as articles in second topic tree. This way I have to make additional querry to get almost "twinnie" article for the first one in first topic tree. In some cases this way of doing make some work very flexible for me. 2. Create only one topic tree, and for example treat $article->view as an option to displays it in many pages. This looks most faster , but I do not know how it will behavioure in one year when number of articles will grow up. Or maybe is there any PHP functions to get querry time? This way I could compare many ways. Piotras --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
