Results 1 to 9 of 9

Thread: How do I Speed up VBA Links?

  1. #1
    Join Date
    Mar 2014
    Posts
    15

    Default How do I Speed up VBA Links?

    It takes FOREVER for it to load. Its so slow its not even funny. Takes at least a minute load! All the other links on my vbulletin install load just fine and are pretty fast. What can I do to make VBA load fast?

  2. #2
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    Default

    vBa Links should be one of the fastest pages on your forums and I'm almost positive I've never heard a single complaint about the loading speed. If you're having trouble, add this line to your includes/config.php file:
    PHP Code:
    $config['Misc']['debug'] = 1
    Then go to your links homepage and add "?explain=1" (without the quotes) to the end of the URL and that should take you to a debugging version of the page. Copy the results, paste them here, and we should be able to tell what's taking so long to load.
    Frequently Asked Questions
    CMPS Users Manual

    For vBadvanced software assistance, please use the support forums.
    Unsolicted PMs, IMs, and email will not be responded to.
    If you have a non-software related question or problem with your account, please submit a support ticket.

  3. #3
    Join Date
    Mar 2014
    Posts
    15

    Default

    Ok here are the results. I did notice that I had a php warning/error somewhere down the page, maybe that's is the problem.

    Code:
    Including Functions.php
    
    Time Before: 0.02571 seconds
    Time After: 0.05460 seconds
    Time Taken: 0.02889 seconds
    
    Memory Before: 1,896.883 KB
    Memory After: 3,141.039 KB
    Memory Used: 1,244.156 KB
    Connect to Database on Server: localhost
    
    Time Before: 0.07943 seconds
    Time After: 0.08155 seconds
    Time Taken: 0.00212 seconds
    
    Memory Before: 3,141.023 KB
    Memory After: 3,141.953 KB
    Memory Used: 0.930 KB
    SQL Query
    
    SET @@sql_mode = ''
    
    Time Before: 0.08195 seconds
    Time After: 0.08210 seconds
    Time Taken: 0.00014 seconds
    
    Memory Before: 3,142.633 KB
    Memory After: 3,143.195 KB
    Memory Used: 0.563 KB
    Datastore Setup
    SQL Query
    
    SELECT *
    FROM vb4_datastore
    WHERE title IN ('adv_links_cats','adv_links_mods','adv_links_opts','adv_links_perms','adv_links_cfield','adv_links_mods','adv_links_rand','bbcodecache','smiliecache','navdata','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream','routes')
    
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	vb4_datastore	range	PRIMARY	PRIMARY	50	 	24	Using where
    
    Time Before: 0.08405 seconds
    Time After: 0.08509 seconds
    Time Taken: 0.00105 seconds
    
    Memory Before: 3,146.766 KB
    Memory After: 3,146.883 KB
    Memory Used: 0.117 KB
    
    Time Before: 0.08224 seconds
    Time After: 0.10350 seconds
    Time Taken: 0.02126 seconds
    
    Memory Before: 3,142.438 KB
    Memory After: 5,467.719 KB
    Memory Used: 2,325.281 KB
    SQL Query
    
    SELECT *
    FROM vb4_datastore
    WHERE title IN ('vbsocial_settings','dbtech_status_category','dbtech_status_mood','reportreasons')
    
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	vb4_datastore	range	PRIMARY	PRIMARY	50	 	4	Using where
    
    Time Before: 0.11639 seconds
    Time After: 0.11647 seconds
    Time Taken: 0.00009 seconds
    
    Memory Before: 6,049.898 KB
    Memory After: 6,050.289 KB
    Memory Used: 0.391 KB
    Session Handling
    SQL Query
    
    SELECT *
    FROM vb4_session
    WHERE sessionhash = 'a5d649428e57e6aedb8a95bf31ee1354'
    	AND lastactivity > 1394582885
    	AND idhash = '5026cfd772903bf0bd8fbe929718ba5e'
    
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	vb4_session	const	PRIMARY,last_activity,guest_lookup	PRIMARY	32	const	1	 
    
    Time Before: 0.11901 seconds
    Time After: 0.11923 seconds
    Time Taken: 0.00022 seconds
    
    Memory Before: 6,105.680 KB
    Memory After: 6,106.023 KB
    Memory Used: 0.344 KB
    SQL Query
    
    SELECT 
    	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
    	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
    	language.phrasegroup_global AS phrasegroup_global,
    	language.phrasegroup_adv_links AS phrasegroup_adv_links,
    	language.phrasegroupinfo AS lang_phrasegroupinfo,
    	language.options AS lang_options,
    	language.languagecode AS lang_code,
    	language.charset AS lang_charset,
    	language.locale AS lang_locale,
    	language.imagesoverride AS lang_imagesoverride,
    	language.dateoverride AS lang_dateoverride,
    	language.timeoverride AS lang_timeoverride,
    	language.registereddateoverride AS lang_registereddateoverride,
    	language.calformat1override AS lang_calformat1override,
    	language.calformat2override AS lang_calformat2override,
    	language.logdateoverride AS lang_logdateoverride,
    	language.decimalsep AS lang_decimalsep,
    	language.thousandsep AS lang_thousandsep
    	
    FROM vb4_user AS user
    LEFT JOIN vb4_userfield AS userfield ON (user.userid = userfield.userid)
    LEFT JOIN vb4_usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN vb4_language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid)) 
    
    WHERE user.userid = 1 LIMIT 1
    
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1	 
    1	SIMPLE	userfield	const	PRIMARY	PRIMARY	4	const	1	 
    1	SIMPLE	usertextfield	const	PRIMARY	PRIMARY	4	const	1	 
    1	SIMPLE	language	system	PRIMARY	 	 	 	1	 
    
    Time Before: 0.12240 seconds
    Time After: 0.12500 seconds
    Time Taken: 0.00260 seconds
    
    Memory Before: 6,116.945 KB
    Memory After: 6,116.172 KB
    Memory Used: -0.773 KB
    
    Time Before: 0.11828 seconds
    Time After: 0.12644 seconds
    Time Taken: 0.00816 seconds
    
    Memory Before: 6,097.609 KB
    Memory After: 6,288.453 KB
    Memory Used: 190.844 KB
    SQL Query
    
    SELECT MAX(permissions & 1) AS perm
    FROM vb4_cms_permissions
    WHERE nodeid = 1 AND usergroupid IN (6)
    
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	vb4_cms_permissions	const	usergroupid,nodeid	usergroupid	8	const,const	1	 
    
    Time Before: 0.17976 seconds
    Time After: 0.17985 seconds
    Time Taken: 0.00009 seconds
    
    Memory Before: 7,183.273 KB
    Memory After: 7,183.680 KB
    Memory Used: 0.406 KB
    
    Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /home/ultimate/public_html/forum/includes/class_database_explain.php:57) in /home/ultimate/public_html/forum/includes/facebook/facebook.php on line 49
    SQL Query
    
    SELECT *
    FROM vb4_style
    WHERE (styleid = 5)
    	OR styleid = 5
    ORDER BY styleid ASC
    LIMIT 1
    
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	vb4_style	const	PRIMARY	PRIMARY	2	const	1	 
    
    Time Before: 0.20149 seconds
    Time After: 0.20172 seconds
    Time Taken: 0.00022 seconds
    
    Memory Before: 7,732.680 KB
    Memory After: 7,733.094 KB
    Memory Used: 0.414 KB
    SQL Query
    
    SELECT * 
    FROM vb4_vbselfdelete_user 
    WHERE userid = '1'
    
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	 	 	 	 	 	 	 	Impossible WHERE noticed after reading const tables
    
    Time Before: 0.20737 seconds
    Time After: 0.20745 seconds
    Time Taken: 0.00008 seconds
    
    Memory Before: 8,397.531 KB
    Memory After: 8,397.992 KB
    Memory Used: 0.461 KB
    End call of global.php: 0.20766711235
    SQL Query
    
    SELECT SUM(views) AS views FROM vb4_adv_links
    
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	vb4_adv_links	system	 	 	 	 	0	const row not found
    
    Time Before: 0.21241 seconds
    Time After: 0.21250 seconds
    Time Taken: 0.00008 seconds
    
    Memory Before: 8,491.242 KB
    Memory After: 8,491.719 KB
    Memory Used: 0.477 KB
    SQL Query
    
    SELECT links.linkid, name, description, linkurl, links.catid, username, links.userid, views, open, links.hasthumb, dateline, lastupdated, votenum, votetotal, customfields.*, NOT ISNULL(subscribelink.linkid) AS issubscribed, posts, links.lastpostid, links.lastpostdateline, links.lastpostuserid, links.lastpostusername, NOT ISNULL(favorites.linkid) AS isfavorite
    				FROM vb4_adv_links AS links
    				 LEFT JOIN vb4_adv_links_cfields_entries AS customfields ON(links.linkid = customfields.lid) LEFT JOIN vb4_adv_links_subscribelink AS subscribelink ON (links.linkid = subscribelink.linkid AND 1 = subscribelink.userid)  LEFT JOIN vb4_adv_links_favorites AS favorites ON (favorites.linkid = links.linkid AND favorites.userid = 1)
    				WHERE valid = 1
    					
    				ORDER BY dateline DESC
    				LIMIT 5
    
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	 	 	 	 	 	 	 	Impossible WHERE noticed after reading const tables
    
    Time Before: 0.22541 seconds
    Time After: 0.22550 seconds
    Time Taken: 0.00010 seconds
    
    Memory Before: 9,001.008 KB
    Memory After: 9,000.766 KB
    Memory Used: -0.242 KB
    SQL Query
    
    SELECT title, template
    FROM vb4_template
    WHERE templateid IN (2274,0,2252,2257,2240,2247,2248,2249,2250,2251,2261,474,476,478,480,482,0,1039,998,1000,1001,0,0,436,430,429,434,435,433,432,437,438,439,745,1030,691,695,692,693,694,1038,0,0,1052,993,715,716,718,719,942,1022,1061,1014,1023,542,541,545,85,1475,0,0,0,1781,1547,1548,777,1550,1553,1554,1555,1556,1557,1561,1600,1599,1603,1602,1613,1609,1606,1900,1901,1899,1392,1936,1644,1412,584,1429,1428,1420,0,1770,1741,1724,1750,1734,1778,1777,1742,1774,1775,1754,1747,2193,2286,2174,2173,2189,2181,1954,1964)
    
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	vb4_template	range	PRIMARY	PRIMARY	4	 	103	Using where
    
    Time Before: 0.23331 seconds
    Time After: 0.23377 seconds
    Time Taken: 0.00046 seconds
    
    Memory Before: 9,348.211 KB
    Memory After: 9,348.180 KB
    Memory Used: -0.031 KB
    SQL Query
    
    SELECT *
    			FROM vb4_livenotifications_usersettings WHERE userid = 1
    
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	 	 	 	 	 	 	 	Impossible WHERE noticed after reading const tables
    
    Time Before: 0.40843 seconds
    Time After: 0.40852 seconds
    Time Taken: 0.00009 seconds
    
    Memory Before: 10,884.719 KB
    Memory After: 10,885.180 KB
    Memory Used: 0.461 KB
    SQL Query
    
    SELECT COUNT(id) AS num FROM vb4_livenotifications
    			WHERE is_read = 0  AND substring(content_type,1,4) = 'mod_'
    
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	vb4_livenotifications	ALL	 	 	 	 	1	Using where
    
    Time Before: 0.48723 seconds
    Time After: 0.48730 seconds
    Time Taken: 0.00008 seconds
    
    Memory Before: 11,066.266 KB
    Memory After: 11,066.672 KB
    Memory Used: 0.406 KB
    SQL Query
    
    SELECT 
    	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
    	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, customavatar.height_thumb AS avheight_thumb, customavatar.width_thumb AS avwidth_thumb, customavatar.filedata_thumb
    	
    FROM vb4_user AS user
    LEFT JOIN vb4_userfield AS userfield ON (user.userid = userfield.userid)
    LEFT JOIN vb4_usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN vb4_avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN vb4_customavatar AS customavatar ON (customavatar.userid = user.userid) 
    
    WHERE user.userid = 1 LIMIT 1
    
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1	 
    1	SIMPLE	userfield	const	PRIMARY	PRIMARY	4	const	1	 
    1	SIMPLE	usertextfield	const	PRIMARY	PRIMARY	4	const	1	 
    1	SIMPLE	avatar	const	PRIMARY	PRIMARY	2	const	0	unique row not found
    1	SIMPLE	customavatar	const	PRIMARY	PRIMARY	4	const	1	 
    
    Time Before: 0.49324 seconds
    Time After: 0.49390 seconds
    Time Taken: 0.00066 seconds
    
    Memory Before: 11,175.359 KB
    Memory After: 11,175.016 KB
    Memory Used: -0.344 KB
    SQL Query
    
    SELECT catid, title, description, parent, parentlist, linkcount, postcount, active, valid, lastlinkid, lastlinktitle, lastlinkusername, lastlinkuserid, lastlinkdateline, lastpostid, lastpostlinkid, lastpostuserid, lastpostusername, lastpostlinktitle, lastpostdateline
    FROM vb4_adv_links_categories
    
    ORDER BY displayorder ASC, haslinks
    
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	vb4_adv_links_categories	ALL	 	 	 	 	2	Using filesort
    
    Time Before: 0.81109 seconds
    Time After: 0.81118 seconds
    Time Taken: 0.00009 seconds
    
    Memory Before: 13,166.609 KB
    Memory After: 13,166.797 KB
    Memory Used: 0.188 KB
    SQL Query
    
    UPDATE vb4_session
    SET lastactivity = 1394583785, location = '/forum/links/?explain=1', badlocation = 0
    WHERE sessionhash = 'a5d649428e57e6aedb8a95bf31ee1354'
    
    Time Before: 0.83822 seconds
    Time After: 0.83860 seconds
    Time Taken: 0.00038 seconds
    
    Memory Before: 13,415.766 KB
    Memory After: 13,415.992 KB
    Memory Used: 0.227 KB
    SQL Query
    
    UPDATE vb4_user
    SET lastactivity = 1394583785,
    timespentonline = 38210
    WHERE userid = 1 AND 1394583785 > lastactivity
    
    Time Before: 0.83886 seconds
    Time After: 0.83924 seconds
    Time Taken: 0.00038 seconds
    
    Memory Before: 13,410.844 KB
    Memory After: 13,411.109 KB
    Memory Used: 0.266 KB
    Page generated in 0.835506916046 seconds with 17 queries, spending 0.00892186164856 doing MySQL queries and 0.826585054398 doing PHP things. Shutdown Queries: DISABLED

  4. #4
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    Default

    "Page generated in 0.835506916046 seconds"

    So that shows the code is being output within less than 1 second. 0.8 actually still seems a bit high, but probably not worth worrying about.
    Can you post the URL to where you have vBa Links installed? If you want to leave out the domain that's fine assuming it's running on the same domain you've entered for your license. I'd like to take a look at the actual page since it's not the PHP script, so the only thing I can figure is perhaps you have some kind of custom JavaScript or perhaps an image or an <iframe> tag in there that's causing the page to load so slowly.
    Frequently Asked Questions
    CMPS Users Manual

    For vBadvanced software assistance, please use the support forums.
    Unsolicted PMs, IMs, and email will not be responded to.
    If you have a non-software related question or problem with your account, please submit a support ticket.

  5. #5
    Join Date
    Mar 2014
    Posts
    15

    Default

    I do not mind posting the entire link. http://ultimaterammstein.org/forum/links/

  6. #6
    Join Date
    Mar 2014
    Posts
    15

    Default

    Also the links is generating these errors that I found with Firefly:

    Code:
    ReferenceError: ln_checknotifications is not defined
    http://connect.facebook.net/en_US/all.js
    Line 28
    
    ReferenceError: ln_checknotifications is not defined
    http://ultimaterammstein.org/forum/links/
    Line 1009
    Possibly it has something to do with this slow issue I'm having.

    EDIT: This is also somehow causing java drop downs to not work in the Links directory where they work all over the rest of the site.

    EDIT 2: Actually the java drop downs are not working in the top bar on the site. They work elsewhere in VBA Links.
    Last edited by HM666; 03-16-2014 at 11:05 AM.

  7. #7
    Join Date
    Mar 2014
    Posts
    15

    Default

    Ok I figured out and fixed the java issue but Links still loads slowly and I need it to load a bit faster. Any tips?

  8. #8
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    Default

    Your vBa Links pages seem to be loading just as quickly as your vBulletin pages for me now, so I'm assuming you were able to figure out the issue?
    Frequently Asked Questions
    CMPS Users Manual

    For vBadvanced software assistance, please use the support forums.
    Unsolicted PMs, IMs, and email will not be responded to.
    If you have a non-software related question or problem with your account, please submit a support ticket.

  9. #9
    Join Date
    Mar 2014
    Posts
    15

    Default

    Quote Originally Posted by Brian View Post
    Your vBa Links pages seem to be loading just as quickly as your vBulletin pages for me now, so I'm assuming you were able to figure out the issue?
    Actually not really, but I did have the host upgrade a portion of the server within the PHP so that may have helped. Thanks.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Speed???
    By ibaker in forum Troubleshooting & Problems
    Replies: 1
    Last Post: 07-25-2008, 01:14 PM
  2. you like speed then take alook at my site!
    By Rideharder1 in forum Show off your vBadvanced!
    Replies: 0
    Last Post: 07-20-2008, 03:28 AM
  3. Speed Issue
    By shelmo in forum Troubleshooting & Problems
    Replies: 4
    Last Post: 05-15-2007, 04:48 AM
  4. IE 7 Speed Problem
    By Rouzbeh in forum Troubleshooting & Problems
    Replies: 1
    Last Post: 05-14-2007, 07:42 AM
  5. How much does vBa affect computer speed
    By DSdad in forum Pre-Sale Questions
    Replies: 1
    Last Post: 03-13-2007, 01:04 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •