performance

while i have read about the 'sometimes un-obvious way' that mod_rewrite handles the various rewrite rules you feed it (eg: first reading…

In many of my queries i have scenario like SELECT * from myTable m where m.userId = :userId AND (m.to = :contactNumber OR m.from = :contactNumber)…

I've setup a nginx server running php 5.3.6 and mysql 5.5.1.3. My computer is an AMD quadcore 9650, 4gb ram, 500gb 7200rpm HD. I ran the PHP MySQL…

i'm processing a form that has a lot of fields for a user who is editing an existing record. the user may have only changed one field, and i would…

Context: We have a PHP/MySQL application. Some portions of the calculations are done in SQL directly. eg: All users created in the last 24 hours…

I'm looking to build a High Performance website. It has thousands of static HTML pages, that are specifically rendered depending on a form submit. I…

Is there a way to collect statistics on the average HTTP response length/size for IIS applications? An indicator for that on perfmon would be nice.…

I'm looking to build a High Performance website. It has thousands of static HTML pages, that are specifically rendered depending on a form submit. I…

I have a simple save-log: XiD (INT) what was saved UiD (INT) who done it TiD (TIMESTAMP) CURRENT_TIMESTAMP With all three fields in the primary key…

I've got a database (MySQL) table with three fields : id, score, and percent. Long story short, I need to do a calculation on each record that looks…

I want to measure performance of my server. The architecture is Apache2 talking to Tomcat over mod_jk. Requests are over HTTPS with mutual…

In my welcome page, I would like to show the total number of users registered with this query: SELECT COUNT(*) FROM USERS Is this a bad idea to make…

I'm looking for tips on how to improve the database performance in the following situation. As a sample application, I wrote a fairly simple app…

For easy allow or disallowing of dynamic IP-adresses you can add them as a hostname in a .htaccess file. As I have read from: .htaccess allow from…

Here is my situation: Situation: I have users, and I have multiple values in multiple categories for each user. The way I see it I have two options:…

My database has table name transactions which has 20000 records. When i run this query SELECT T1.* FROM transactions AS T1 WHERE T1.ppno IN (SELECT…

I'm currently redesign a heavy loaded website, and I would appreciate any opinion about a specific database design issue. The concept is to keep in…

I have a very gerneral question: 1.) Given I have a transaction (in mysql) that comprises the modification of ten-/hundred thousand or even million…

I'm working on a query for a news site, which will find FeaturedContent for display on the main homepage. Content marked this way is tagged as…

If you configure Apache to enable gzip compression for your static HTML/CSS/JS/etc. files, it automatically outputs a gzipped version to any client…