phpBB2Refugees.com Logo
Not affiliated with or endorsed by the phpBB Group

Register •  Login 

Continue the legacy...

Welcome to all phpBB2 Refugees!Wave Smilie

This site is intended to continue support for the legacy 2.x line of the phpBB2 bulletin board package. If you are a fan of phpBB2, please, by all means register, post, and help us out by offering your suggestions. We are primarily a community and support network. Our secondary goal is to provide a phpBB2 MOD Author and Styles area.

Speedproblem

Goto page Previous  1, 2
 
Search this topic... | Search phpBB2 Discussion... | Search Box
Register or Login to Post    Index » phpBB2 Discussion  Previous TopicPrint TopicNext Topic
Author Message
drathbun
Board Member



Joined: 24 Jul 2008

Posts: 653
Location: Texas


flag
PostPosted: Fri Sep 24, 2010 12:57 pm 
Post subject: Re: Speedproblem

You can use phpMyAdmin to create an index, or you can do it directly with SQL statements.
Code:
create index topic_last_post_id on phpbb_topics(topic_last_post_id)

The last post is used to retrieve the date/time of the last post as well as the last poster name. On a standard phpBB2 board those fields are displayed on the index page.

MySQL Create Index syntax

_________________
phpBBDoctor Blog
Back to top
drathbun
Board Member



Joined: 24 Jul 2008

Posts: 653
Location: Texas


flag
PostPosted: Tue Sep 28, 2010 5:01 pm 
Post subject: Re: Speedproblem

Any luck?
_________________
phpBBDoctor Blog
Back to top
Holger
Board Member



Joined: 19 Jan 2009

Posts: 509
Location: Hanover


flag
PostPosted: Tue Sep 28, 2010 6:03 pm 
Post subject: Re: Speedproblem

Ups! SORRY!
I optimized much of the code last week. Forgot about this!

Can I destroy something when creating the index?
I am not showing anything like last poster or last post time or such on my index:
http://www.maskinisten.net/index.php

_________________
Love your data! Back it up!
Back to top
drathbun
Board Member



Joined: 24 Jul 2008

Posts: 653
Location: Texas


flag
PostPosted: Wed Sep 29, 2010 1:57 pm 
Post subject: Re: Speedproblem

Creating an index on the database should not impact the information displayed on your screen. It doesn't change the code.
_________________
phpBBDoctor Blog
Back to top
Holger
Board Member



Joined: 19 Jan 2009

Posts: 509
Location: Hanover


flag
PostPosted: Wed Sep 29, 2010 2:09 pm 
Post subject: Re: Speedproblem

Ok! Created it.
But I have optimized so much in the past week that I wont see a difference I think ...
[ Time: 0.5673s ][ Queries: 27 (0.1537s) ]

_________________
Love your data! Back it up!
Back to top
Display posts from previous:   
Register or Login to Post    Index » phpBB2 Discussion  Previous TopicPrint TopicNext Topic
Page 2 of 2 All times are GMT
Goto page Previous  1, 2
 
Jump to:  

Index • About • FAQ • Rules • Privacy • Search •  Register •  Login 
Not affiliated with or endorsed by the phpBB Group
Powered by phpBB2 © phpBB Group
Generated in 0.0168 seconds using 15 queries. (SQL 0.0020 Parse 0.0005 Other 0.0143)
phpBB Customizations by the phpBBDoctor.com
Template Design by DeLFlo and MomentsOfLight.com Moments of Light Logo