x
This website is using cookies. We use cookies to ensure that we give you the best experience on our website. More info. That's Fine
HPC:Factor Logo 
 
Latest Forum Activity

Why can't I see more than one page of threads?

1 2
deusexaethera
deusexaethera Page Icon Posted 2007-10-16 1:06 PM
#
Status:
There's no "Next Page" button. I can't see anything unless it's on Page 1. Which really sucks, because there's something I'm looking for right now.
 Top of the page Quote Reply
C:Amie Page Icon Posted 2007-10-16 1:41 PM
#
Avatar image of C:Amie
Administrator
H/PC Oracle

Posts:
17,976
Location:
United Kingdom
Status:
Moved to HPC:Factor discussion

Use the filters on the bottom left of the forum view to extend the database pull
 Top of the page Quote Reply
deusexaethera
deusexaethera Page Icon Posted 2007-10-16 2:19 PM
#
Status:
There are no restrictions on the database pull. It's pulling all dates. I still only see a single page, with no "Next" button.
 Top of the page Quote Reply
cmonex Page Icon Posted 2007-10-16 3:48 PM
#
Avatar image of cmonex
H/PC Oracle

Posts:
16,175
Location:
Budapest, Hungary
Status:
you need to explicitly press "Go"
 Top of the page Quote Reply
CE Geek Page Icon Posted 2007-10-16 4:04 PM
#
Avatar image of CE Geek
Global Moderator
H/PC Oracle

Posts:
12,667
Location:
Southern California
Status:
That's by "Jump to forum," cmonex.

Isn't there more than one page number next to "Jump to page"?
 Top of the page Quote Reply
cmonex Page Icon Posted 2007-10-17 1:18 AM
#
Avatar image of cmonex
H/PC Oracle

Posts:
16,175
Location:
Budapest, Hungary
Status:
CE Geek, no, you misunderstand. he wants to jump between threads, and so my answer is completely relevant.
 Top of the page Quote Reply
CE Geek Page Icon Posted 2007-10-17 1:32 AM
#
Avatar image of CE Geek
Global Moderator
H/PC Oracle

Posts:
12,667
Location:
Southern California
Status:
Ah - slight semantic difference. I thought he meant the first page of each thread.
 Top of the page Quote Reply
deusexaethera
deusexaethera Page Icon Posted 2007-10-17 2:04 AM
#
Status:
I don't want to "jump" anywhere. I want to see Page 2 of the LIST of threads -- you know, the list that appears when you open a forum.



(no_page_2_dammit!.jpg)



Attachments
----------------
Attachments no_page_2_dammit!.jpg (98KB - 0 downloads)
 Top of the page Quote Reply
CE Geek Page Icon Posted 2007-10-17 2:10 AM
#
Avatar image of CE Geek
Global Moderator
H/PC Oracle

Posts:
12,667
Location:
Southern California
Status:
Yeah, it doesn't show the subsequent pages in the default "All years" and "All months" setting. As C:Amie and cmonex are saying, select a year and a month and then click on "Go."
 Top of the page Quote Reply
deusexaethera
deusexaethera Page Icon Posted 2007-10-17 2:11 AM
#
Status:
Okay, so what's wrong with it, and what does it take to fix it? I'm not a vBulletin whiz, but might be able to help.
 Top of the page Quote Reply
cmonex Page Icon Posted 2007-10-17 2:14 AM
#
Avatar image of cmonex
H/PC Oracle

Posts:
16,175
Location:
Budapest, Hungary
Status:
why do not you read what i say? just press one of the Go buttons there..

it is nothing wrong with it, designed in this way by C:Amie to reduce load on the servers. it was different a long time ago and i dont like this new arrangement but oh well.
 Top of the page Quote Reply
CE Geek Page Icon Posted 2007-10-17 2:17 AM
#
Avatar image of CE Geek
Global Moderator
H/PC Oracle

Posts:
12,667
Location:
Southern California
Status:
LOL at the screenshot name
 Top of the page Quote Reply
deusexaethera
deusexaethera Page Icon Posted 2007-10-17 10:43 AM
#
Status:
Quote
cmonex - 2007-10-17 2:14 AM

why do not you read what i say? just press one of the Go buttons there..

it is nothing wrong with it, designed in this way by C:Amie to reduce load on the servers. it was different a long time ago and i dont like this new arrangement but oh well.


I always read what you say, cmonex. You didn't explain the reason for the functionality until just now. Still, I'm not sure I see how it reduces the load on the server to remove a set of page number hyperlinks. The query that pulls the next set of matching database items doesn't need to run until I click "Next Page".

Edited by deusexaethera 2007-10-17 10:43 AM
 Top of the page Quote Reply
C:Amie Page Icon Posted 2007-10-17 11:49 AM
#
Avatar image of C:Amie
Administrator
H/PC Oracle

Posts:
17,976
Location:
United Kingdom
Status:
Easy, the database doesn't magically know how many pages there it has to iterate the value. The original forum core that we populated had to query the integer value for the page count, generate the page information and preform the divisible mathematics every single time someone loaded forum-view.asp. It was killing the SQL Server.

Yes it can be fixed with cache algorythms and some hash tables to map data, indices and output strings together, but the only necesity I have for doing that is that google et al cannot index us beyond the first 30 results.
 Top of the page Quote Reply
deusexaethera
deusexaethera Page Icon Posted 2007-10-19 11:10 AM
#
Status:
You don't have to query and parse the ENTIRE contents of the forum to find out whether there's more than a single page.

When you query the database for thread names, set a cap of 31 results. If 31 results are returned, display 30 and add a "Next Page" hyperlink. If 30 or fewer results are returned, display all of the results and don't add the link.

If the first thread on the page has an index of 0 (or however the first thread in the forum is labeled), don't display a "Previous Page" hyperlink. If the first thread on the page has an index >0, do display the link.

Edited by deusexaethera 2007-10-19 11:12 AM
 Top of the page Quote Reply
1 2
Jump to forum:
Seconds to generate: 0.204 - Cached queries : 67 - Executed queries : 9