ok guys im trying to optimise my scripts to run faster, i need some help (noob) :(. im using phpmyadmin to access my info. here goes.... 1. is it better to have all my tables under the one database, or better to have multiple databases? 2. most of my columns are varchar 255, is this ok or is char 255 better? (size isnt an issue, only speed) 3. how do i index my database? iv read up on this but still a bit lost... 4. in phpmyadmin i ran a simple search SELECT * FROM `searchbooks1` and the query returned results in 0.0009 sec but when i do this through my website, i.e search for books, it takes ages, is this a server issue? ok, thats it for now, unless there is anything i missed that will speed up my site. the site is studyleave.com (mentioned previosuly) any help would be very much appreciated. thanks