I'd guess that joins - with the right foreign keys - are better than unions, but this is only going to impact indexing times, not search query times. If you have three separate concepts, then have three separate tables and three separate indices to match.
-- Pat On 12/10/2013, at 11:16 AM, Sr K1 <[email protected]> wrote: > Hello, > > I am working on small meta search engine with not more than 20-30 million > rows. > I am thinking mysql with myisam as its gonna be only read-only DB and no > inserts/update/delete will be there. > > i need few suggestions . > > will using join/union in query slow down the result output time ? > > becuase i am planning to create 3 separate tables with assigning ID to > categories and so. > > or should i create a single big table with all the details in it and then > create multiple indexes to look from ? > > > thanks for your time. > > > -- > You received this message because you are subscribed to the Google Groups > "Thinking Sphinx" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/thinking-sphinx. > For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/thinking-sphinx. For more options, visit https://groups.google.com/groups/opt_out.
