3 ms·

I would: * Change the landing page you have up there. Focus on the product (not your current predicament). A few screeshots. Make people want to comeback later

I would: * Change the landing page you have up there. Focus on the product (not your current predicament). A few screeshots. Make people want to comeback later today or tomorrow. * Eliminate any non-essential database calls. Convert php files to static html (or copy and paste the output of the page and just echo it). * Check your slow query logs in mysql and index. Definitely make sure you have any primary keys set and foreign keys (used in joins) indexed. Then look at your queries and add index on your slowest queries. If you aren't sure it's MySql, copy all of your images onto Rackspace cloud files/amazon s3. This will lower traffic through your machine/disk access.

wesleyzhao 16y ago
We wanted to really focus on our story since we are hoping people will continue to use the apps we create and they will know us for being people the love. Rather than just focusing on the product. We have combed through the code and believe we have eliminatd non-essential database calls but will look again. Also I guess we could always use static html for header/footer rather than including/requireing it. *What is a slow query log?
- sfrench 16y ago
  | What is a slow query log? It's basically a log kept of queries that are running slower than a set threshold. Read through this for the details to set it up and access it: http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html