Adbanced PHP/MYSQL Books

[Todd W]

Does anyone know of any good advanced php and/or mysql books? (They can be separate.)

I'm looking for techniques for designing applications that require extensive configuration files and what's the best way to store that data in mysql. I want to make sure it runs fast and also don't want to store the configuration in a php file, and I know big apps like vbulletin do this, and I'd like to learn as much as possible about designing large applications that work efficiently.

I know about database normalization and consider myself a good php / mysql developer but I'd like to take my skill to the NEXT level.

Thanks
-Todd

[ASP-Hosting.ca]

Check out "PHP and MySQL Web Development" its a good book - I have the second edition, but there is a third now...

[Todd W]

Check out "PHP and MySQL Web Development" its a good book - I have the second edition, but there is a third now...

I have that one already.

Thanks
-Todd

[Nico]

I don't have 1 specific book to recommend, but for what you said, it might be better to look for 2 or 3 different books.

One that focus on database optimization for large websites and specifically MySQL.
And other to find out about PHP best practices and ways of "going to the next level" in your development. You probably want to look at OOP programming, MVC, Frameworks and related stuff.

You can find some really interesting info on how big websites work, by looking at the case studies of this sites. Specially when they talk about how and why they changed databases or programming languages, how they optimized the db, caching, servers architectures, programming techniques, etc.

[alien]

"High Performance MySQL - O'Reilly" and "MySQL Database Design and Tuning - MySQL" are good. And sites like http://www.planetmysql.org/ , http://www.mysqlperformanceblog.com/ , http://www.planet-php.org/ , etc,.