Databases
StackOverflow2013
Postsdbo
POHow to optimize this website. Need general advices
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to optimize this website. Need general advices
    primarykey
    data
    text
    <p>this is my first question here, which is regarding a specific website optimization. A few moths ago, we launched <a href="http://www.kissid.ro" rel="nofollow">www.kissid.ro</a> for one of our clients which is some kind of community website.</p> <p>Everything works great, but now this website is getting bigger and it shows some slowness when the pages are loading. </p> <p>The server specs:<br> - PHP 5.2.1 (i think we need to upgrade on 5.3 to make use of the new garbage collector)<br> - Apache 2.2<br> - Quad Core Xeon Processor @ 2,8 Ghz and 4 GB DDR 3 RAM.<br> - XCACHE 1.3 (we added this a few months ago)<br> - Mysql 5.1 (we are using innodb as engine)<br> - Codeigniter framework </p> <p>Here is what we did so far and what we intend to do further :</p> <p>Beside xcache, we don't really use a caching mechanism because most of the content comes live and beside this, we didn't wanted to optimize prematurely because we didn't know what to expect as far as the traffic flow. On the other hand, we have installed memcached and we want to implement a cache system based on memcached.</p> <p>Regarding the database structure, we have reached 3NF with most of our tables, and yes we have some slow queries(which we plan to optimize) but i think because the tables that produce slow queries are the one for blog comments(~44,408 rows) / user logs tracking (~725,837 rows) / user comments (~698,964 rows) etc which are quite big tables. The entire database is 697.4 MB in size for now. </p> <p>Also, here are some stats for January 2011:<br> Monthly unique visitors: - 127.124<br> Monthly unique views: 4.829.252<br> Monthly unique visits: 242.708 </p> <p>Daily average:<br> Unique new visitors: 7.533<br> Unique new views : 179.680 </p> <p>Just let me know if you need more details.<br> Any advice is highly appreciated.</p> <p>Thank you.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USTwisted1919
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow to optimize this website. Need general advices
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POHow to optimize this website. Need general advices
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POHow to optimize this website. Need general advices
      1. USBrynJ
      1. VTFavorite
    1. COGot any profiling results? What causing pages to load slow? Network? Database? 3-rd party services? What is page generation time? What page slowest of them all? What part of this page causing that?
      singulars
      1. POHow to optimize this website. Need general advices
      1. USYour Common Sense
    2. COHowever, I'd shoot in the dark into user logs tracking general direction...
      singulars
      1. POHow to optimize this website. Need general advices
      1. USYour Common Sense
    3. COIt sounds like you're looking for a magic wand that will make everything faster. There isn't one. First you need to identify your bottleneck. Step through the code, get debug/trace information directly from what's running in Production if you have to. But you need to know what's slowing you down before you can fix it.
      singulars
      1. POHow to optimize this website. Need general advices
      1. USDavid
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload