Creating indices for bt_items sql to speed up self hosted server

Get Started | Login

Discussion Forums > Self Hosted Control Panels

Replies: 2 Views: 67

jordanko I hate code! Posts: 21 Reg: Nov 07, 2011 Miami 210	confirm \| cancel 10/29/13 11:47 PM (12 years ago) Creating indices for bt_items sql to speed up self hosted server Hi all. I've been experiencing long load times on my self-hosted server when I press the "screens" button on apps that have 100+ screens. I'm talking really long - like over a minute. I moved my install from hostmonster to site5's cloud and while everything sped up dramatically, the load time for the "screens" function is still long. I'm thinking it might be an SQL issue with my bt_items table, but I'm no where fluent when it comes to SQL. Anyone else have this problem? Anyone have any ideas on how to optimize the SQL table? Maybe some new indices? Any help would be much appreciated. Thanks! Title Comments Hi all. I've been experiencing long load times on my self-hosted server when I press the "screens" button on apps that have 100+ screens. I'm talking really long - like over a minute. I moved my install from hostmonster to site5's cloud and while everything sped up dramatically, the load time for the "screens" function is still long. I'm thinking it might be an SQL issue with my bt_items table, but I'm no where fluent when it comes to SQL. Anyone else have this problem? Anyone have any ideas on how to optimize the SQL table? Maybe some new indices? Any help would be much appreciated. Thanks!

WolfTimJ buzztouch Evangelist Posts: 810 Reg: Feb 20, 2011 Rockwall, TX 17,400	10/30/13 12:37 PM (12 years ago) I have several apps with over 100 screens and notice no lag. I'm hosted with HostGator but don't know if that has anything to do with your issue. Maybe a broadband speed issue? Dunno. Tim Comments I have several apps with over 100 screens and notice no lag. I'm hosted with HostGator but don't know if that has anything to do with your issue. Maybe a broadband speed issue? Dunno. Tim

jordanko I hate code! Posts: 21 Reg: Nov 07, 2011 Miami 210	10/30/13 12:54 PM (12 years ago) It doesn't seem to be a broadband issue. My connection is around 40mbps, and I switched to the site5 cloud from hostmonster (which is the same company as hostgator, bluehost, and justhost) and things sped up. On hostmonster I was downloading from my sql server at 2mbps and html server at 5mbps, and on site5 the sql downloads at 10mbps and html at 20mbps. The lag has decreased dramatically, but still stands at about 25 seconds to load the screens menu. Curiously enough it took the same 25 seconds to load an app with 92 screens as it did to load one with 541 screens. I'm thinking it has something to do with the sql database - maybe rows marked for deletion, bad indices, etc. - but fixing sql is a little out of my league. The bt_items table is a little under 15,000 rows so it's not that big. I'm not too sure what to do to speed it up. Comments It doesn't seem to be a broadband issue. My connection is around 40mbps, and I switched to the site5 cloud from hostmonster (which is the same company as hostgator, bluehost, and justhost) and things sped up. On hostmonster I was downloading from my sql server at 2mbps and html server at 5mbps, and on site5 the sql downloads at 10mbps and html at 20mbps. The lag has decreased dramatically, but still stands at about 25 seconds to load the screens menu. Curiously enough it took the same 25 seconds to load an app with 92 screens as it did to load one with 541 screens. I'm thinking it has something to do with the sql database - maybe rows marked for deletion, bad indices, etc. - but fixing sql is a little out of my league. The bt_items table is a little under 15,000 rows so it's not that big. I'm not too sure what to do to speed it up.

Login + Screen Name Required to Post Login to participate so you can start earning points. Once you're logged in (and have a screen name entered in your profile), you can subscribe to topics, follow users, and start learning how to make apps like the pros.