at the moment the database is almost empty as its a fresh install. have run the query in php myadmin and its showing 29 rows ( http://prntscr.com/6tcnf4 )
I appreciate that as the db grows that this will increase considerably, so what would be the best way to optimise the query? what would the 'best practice' be for creating full searchability for a visitor?