December 22, 2024, 02:30:45 AM

1,531,361 Posts in 46,734 Topics by 1,523 Members
› View the most recent posts on the forum.


~Gri to Khadafi~

Started by gri, July 19, 2011, 02:35:17 AM

previous topic - next topic

0 Members and 2 Guests are viewing this topic.

Go Down

Daddy

Also as mentioned on this thread http://www.simplemachines.org/community/index.php?topic=33496.msg250043#msg250043 it slows down mysql queries very much since it has to search through (in our case) over 1 million posts for a single post.

This also problematic since a message id will be a unique number and will also return a single index but searching text may not always return a unique result.  As a programmer I wouldn't want to enable something that will vastly reduce the speed of a query and introduce errors.

gri

Quote from: Khadafi
Also as mentioned on this thread
http://www.simplemachines.org/community/index.php?topic=33496.msg250043#msg250043
it slows down mysql queries very much
since it has to search through (in our case) over 1 million posts for a single post.


Quote from: .. gri
http://www.simplemachines.org/community/index.php?msg=250043 .

Publish the display delay values for this format
on an example of several measures (three at least).


Daddy

July 19, 2011, 02:47:56 PM #17 Last Edit: July 19, 2011, 02:52:26 PM by Khadafi
You'd want to do that with an Object Database not a relational database. 

Doing that on SMF would require a rewrite

As for including the title in the URL there are some issues other than simply being significantly slower.

You are Russian, yes. Say that you have posted a title using the Cryllic alphabet.  If a user doesn't have the ability to read Cryllic characters then the link will not work at all as he may not be able to see the characters.

It will also cause other issues. a cleverly crafted thread title can cause problems with XSS if a way to execute Javascript is encountered. Certain characters may prematurely truncate a url or redirect elsewhere. 


Quick demo.  Try to set your URL to include "topic=;" and it won't go to the thread.


gri

Quote from: Khadafi
As for including the title in the URL
there are some issues other than simply being significantly slower.


You misunderstood.
I am standing against including the titles into urls.

There is neither title nor "topic=" parameter
in the format:

http://www.simplemachines.org/community/index.php?msg=250043 .

Page created in 0.101 seconds with 27 queries.

Publish your value.
Show the slowness in comparison with the default link format display delay.

Daddy

I do see what you mean and you can add ;topic="whatever" to any thread really and it will work
For example: http://boyah.net/forums/index.php/topic,54817.15.html;topic=~Khadafi-to-gri~
The last parameter does not touch the database and will not slow it down. I had initially thought you wished to define thread URLs by the title.

However our URL is formated this way for search engine optimization.  It creates less errors with multiple page threads when the URL isn't defined by a bunch of query strings.

Reverting back to the "non pretty urls" would hurt our search engine rankings.



gri

Have we finished up
with a tale about slowness down
by unique message link format ?






Quote from: Khadafi
you can add ;topic="whatever" to any thread really and it will work
For example: http://boyah.net/forums/index.php/topic,54817.15.html;topic=~Khadafi-to-gri~


I am speaking about POST searching and positioning,
not the topic (or topic page) display like in
http://boyah.net/forums/index.php/topic,54817.15.html .

On the contrary, i am removing topic id from the links.

A post is NOT RELATED with the topic forever.

~An ambrion does not stay inside his Mother's womb..
after He wanted to become Free.~

And, unlike the womb, the Free Post can be returned back..


Quote from: Khadafi
However our URL is formated this way for search engine optimization.


Is ".html" needed for search engine optimization ?
I do not understand it.
Maybe search engine itself should be better developed ?

Quote from: Khadafi
Reverting back to the "non pretty urls"
would hurt our search engine rankings.


Where do you use pretty urls ?
Pretty Urls mod inserts the boards/topics titles to the url, doesn't it ?

Daddy




Quote from: gri on July 19, 2011, 04:38:27 PM
Have we finished up
with a tale about slowness down
by unique message link format ?
Yes since I now know what you are referring to



Quote
I am speaking about POST searching and positioning,
not the topic (or topic page) display like in
http://boyah.net/forums/index.php/topic,54817.15.html .

On the contrary, i am removing topic id from the links.

A post is NOT RELATED with the topic forever.

~An ambrion does not stay inside his Mother's womb..
after He wanted to become Free.~

And, unlike the womb, the Free Post can be returned back..
Are you talking about what I did to my child;____;


Or are you referring to splitting and merging topics?
So rather than the topic ID you'd prefer links to the individual message ide.

Quote
Is ".html" needed for search engine optimization ?
I do not understand it.

Essentially having a URL such as "boyah.net/forums/index.php/topic30303.html fairs better in terms of SEO than "boyah.net/forums/index.php?topic=30303";
Quote
Maybe search engine itself should be better developed ?

I don't think I can fix the issue of search engines needing to be better developed.  Q('_' Q)

Quote
Where do you use pretty urls ?
Pretty Urls mod inserts the boards/topics titles to the url, doesn't it ?

Oops not pretty urls.

In the admin panel under "Features and Options" there is a checkbox "   Search engine friendly URLs" 

"This changes the format of URLs a little so search engines will like them better. They will look like index.php/topic,1.html."

gri

Quote from: Khadafi
Are you talking about what I did to my child;____;


Sorry, no i didn't.
What did you do ?
Sorry.

PM me.. if it was not a public action.

Daddy

It was an unfunny joke, no worries.  giggle;

gri

Quote from: Khadafi
"This changes the format of URLs a little so search engines will like them better.
They will look like index.php/topic,1.html."


The ~Freedom of Moving Thoughts~ mod

should provide the correspondence with the replacement of

"They will look like index.php/topic,1.html."

with the

"They will look like http://boyah.net/forums/msg=1069555.html ."


in original value of $helptxt['queryless_urls'] variable

  in Modifications.*.php .




Will you try to code the mod ?

gri

Quote from: Khadafi
Do you have any example posts?


You have missed an example of the operable grace link:

Quote from: gri
There is neither title nor "topic=" parameter
in the format:

http://www.simplemachines.org/community/index.php?msg=250043 .


The monkeys have failed to argue
with First Human banned from Simple Machines of the Earth
since SMF 2.0 Beta 1 :

Quote from: gri
Quote from: change_log.txt
SMF 2.0 Beta 1    August 25, 2007

July 2006

+ Added the ability to specify a message id
  using the msg variable of REQUEST
  to access a particular message. (Load.php)



Daddy

I may look into it some time.

http://boyah.net/forums/index.php/topic,54826.0.html also i do not know if you have seen this.

gri

July 21, 2011, 12:09:54 AM #27 Last Edit: July 21, 2011, 12:14:36 AM by gri
Quote from: Khadafi
also i do not know if you have seen this.
http://boyah.net/forums/index.php/topic,54826.0.html


You can not and should not be sure
that the post you have linked to by the url with the topic id only
will always remain in the display of the same topic..
i.e. will never become Free.

Modify the link in your original post
to the format of the url with the message id included obligatorily..

while the topic id included in the url at the moment only
as no more than an Evolutionary Atavism

which soon will not participate
in the ~Grivitational Integrity Defence~ Movement
                                        of Universe Humanity.

gri


Daddy

If I removed the mod concerning line numbers then how could someone easily identify an error when posting code? Giving a line number provides a simple way to say "remove the if statement from line n".

I don't even think I have a mod for that.

Go Up