page speed issue

i have create one new app using yii but my web page speed is very low so can any one tell me how to increase my page speed

is it only one page that is slow or in general the whole application?

if is only one page, does it do a big query?

did you check yii debug how long the query take?

which kind of database do you use?

did you set index on you tables?

did you set mixed index based on the more common search?

did you enabled caching?

did you enabled query caching for the schema?

People are willing to help but at least try to help a bit giving some info…

it is in whole application. i have use mysql for it.and i have check in yii debug it will take 8 to 9 sec for execute

did you set index on you tables?

did you set mixed index based on the more common search?

did you enabled caching?

did you enabled query caching for the schema?

please tell me solution for above question. i have never try this in my application

It is TOO SLOW. I guess something is wrong with your server environment.

Did the skeleton app run with a normal speed when you first created it from the project template? Or did it become slow after you had added something?

So at first lets start with the base.

Do you have yii2-debug installed? Normally the answer is yes since is come with any yii2 application template.

at the bottom of your page you should have the debug toolbar, which if it is closed is a tag on the bottom right of the browser with yii logo :

click it to open, once expanded you have a resume of the execution of the current page:

  • Time is the total execution time
  • Memory is the memory used by the script
  • DB are related to database, 12 are the number of executed query, and 68ms are the total time of query execution

Already from here you can understand if your slowness come from the db query.

If you click on any part of the toolbar you get in to the details

For more detail refer to the manual:

http://www.yiiframew…ebug-index.html

or this video for brief introduction

https://www.youtube…h?v=6LAFdnApLH8

i have use yii 1.1.17 version in my application

i have use some external javascript, bootstrap. so is that the reason my app will work slow…??

and all data display dynamically on my application.

This is the forum for yii2.

there is a debug toolbar for yii1 too, try to use it.

http://www.yiiframework.com/extension/yii-debug-toolbar

Always post in the correct forum to get better support.

About your external resource, do you mean that these javascript /css are on a different server?

If you suspect that the slowness come form some assets download you can use firefox with firebug extension, under the net panel you will find the info about download time of every single resource.

[color="#006400"]/* Moved from 2.0 to 1.1 */[/color]

my javascript/css, database and all my file in in same server.