Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>CodeIgniter is one of the fastest frameworks but the only thing that it means is that if the same programmer uses CodeIgniter and, for example, ZendFramework and if the code is approximately similar for both of them, the application will probably be faster with CI. But it doesn't mean that CI will help someone build better <strong>architecture</strong>, so the developer can be either the slowest or fastest part of any framework.</p> <p>I agree with pestaa that <strong>database optimization</strong> is one of the most critical things to do. Read about indexes, MySQL performance (if you're going to use MySQL), best practices and so on.</p> <p>Another thing to consider is <strong>caching</strong>. CI caching is bad so use third-party caching libraries. There is a lot of information on CI forum on this topic and you should choose which library is better for you.</p> <p>Also, read about <strong>lazy load</strong>. Try to load only necessary information (images, texts and so on) and, in some cases, it will help you improve performance.</p> <p>If you're going to implement a <strong>full-text search</strong>, don't use MySQL for this purpose, because such operators as LIKE and MATCHES are pretty slow. Instead, I recommend using something like <strong>Sphinx Search</strong> or other search engines. I recommend Sphinx because it's fast and flexible, it has great documentation, the new version supports real-time indexing, integration with MySQL (SphinxSE) and it also supports MySQL binary protocol (look for SphinxQL if interested). It will take some time to get started and become familiar with Sphinx but the more you work with this engine, the more amazed you'll be. This engine is used by ThePirateBay and other big projects so it's suitable for high traffic websites.</p> <p><strong>Cogear</strong> is a great CMS which is based on a slightly modified CodeIgniter framework (it supports HMVC and some other types of plugins). Developers swear that it has much better performance than WordPress (which sometimes serves pretty popular websites and blogs). Unfortunately, their website is exclusively in Russian.</p> <p>CI is ok but if you want an alternative, I recommend you to give a try to <strong>Yii framework</strong>. It's a fast and powerful PHP framework with a lot of amazing features.</p> <p>Good luck!</p>
    singulars
    1. This table or related slice is empty.
    1. POBuilding high traffic site using Codeigniter
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USArmen Markossyan
    1. USArmen Markossyan
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POBuilding high traffic site using Codeigniter
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

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