|
|
Welcome to the Computer Webmaster Gaming Console Graphics Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
| |||||||
| Database Database problems or need to ask a question? maybe something to do with sql injections or a database software question. Database topics cover MySQL, PostgreSQL, Oracle, SQL Server or anything else related to databases. |
 |
| | LinkBack | Thread Tools | Display Modes |
07-01-2007, 9:35 PM
| #1 | ||
 |
Went through most of my MySQL calls (I used mod_perl on linux). Cleaned up everything, removed unnecessary queries, made MySQL do all joins (including outer joins), instead of doing sub-searches on my part, replaced constructs such as: if select count(*) > 0 then update else insert with INSERT ... ON DUPLICATE KEY UPDATE etc. The result is a cool 3-4x speedup on most pages, as measured by Apache Bench (ab). So... it pays to look at database usage closely! MANY THANKS TO ALL FOR YOUR RECENT SUGGESTIONS!!! i | ||
      |
| Featured Websites | ||||
|
|
| Tags: algebracom, site, sped, times |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Acquisition times | Mike | GPS | 2 | 06-25-2007 11:57 PM |
| - USA TIMES - | geoffbaker | Building An Internet Business | 0 | 06-11-2007 12:17 AM |
| Ask me how to win Lotto 8 out of 10 times! | online@email.com | Building An Internet Business | 0 | 06-11-2007 12:17 AM |
| Ask me how to win Lotto 8 out of 10 times! | online@email.com | Building An Internet Business | 0 | 05-29-2007 3:14 AM |
| USA TIMES | geoffbaker | Building An Internet Business | 0 | 05-29-2007 3:06 AM |
| Featured Websites | ||||
|
Sped up my site algebra.com by 3 times. 
PacMan
Linear Mode
