Hi there i am trying to work out the most efficient way to list say multiple categories of entries, the database is quite large about 200 meg.
I would like to know if using join tables is more efficient than storing the keys in a varchar field then within the second loop doing a where in (1,2,3,4) where the 1,2,3,4 are the stored category keys in the varchar field rather than a where in (1), where 1 is the pirmaryID of the entry for instance ? i was told the join table could be slow on a large database let me know thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
