MySQL Forums
Forum List  »  PHP

Re: charset / collation
Posted by: Andreas Schnederle-Wagner
Date: October 18, 2016 02:06AM

Of course it's only connecting once for every Page/Ressource Call - and the SET NAMES is also only called once after making the Connection.

As you guessed - there are a lot of quick connections as for example all Ressources (Images, PDFs, ...) are delivered through Wrapper Scripts which call the DB for Access Rights, Folder/Domain Delivery Permissions, ...

So for example - For every JPG called there is
- DB connection
- SELECT DB
- SET NAMES
- 1 - 4 SQL Queries - depending where on the FS the Image is

So the idea is getting rid of the SET NAMES Query and save ~11% of all Queries ... (10 - 80 Queries / Second - which I guess will bring a bit performance / lower LOAD AVG on DB Server ... ?)
But as the System is running fine for years now I need to ensure no problems arise with my optimizations ... ;-)

Of course I also test on a staging ENV - but as the System is that extensive it's simply not possible to test all & everything - that's why I also ask if someone knows if this is working ... ;-)

Options: ReplyQuote


Subject
Written By
Posted
October 13, 2016 09:32AM
October 13, 2016 12:12PM
October 14, 2016 09:17AM
October 14, 2016 02:58AM
October 17, 2016 04:21PM
Re: charset / collation
October 18, 2016 02:06AM
October 18, 2016 09:41AM
October 18, 2016 11:22AM
October 16, 2016 04:03PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.