Re: charset / collation
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 ... ;-)
Subject
Written By
Posted
Re: charset / collation
October 18, 2016 02:06AM
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.