• [MOD] Google Friendly Urls For 4images Best Seo Mod 4 0 5 1
Currently:  

Author Topic: [MOD] Google Friendly Urls For 4images Best Seo Mod  (Read 708159 times)

0 Members and 1 Guest are viewing this topic.

Offline metal_brain

  • Jr. Member
  • **
  • Posts: 90
  • For all the reasons we have to die
    • View Profile
Re: [MOD] Google Friendly Urls For 4images Best Seo Mod
« Reply #150 on: October 27, 2008, 06:45:39 AM »
Thanks V@no  :D
as usual u r very helpful

Offline Sunny C.

  • Addicted member
  • ******
  • Posts: 1.805
  • I ♥ 4I
    • View Profile
Re: [MOD] Google Friendly Urls For 4images Best Seo Mod
« Reply #151 on: October 27, 2008, 07:49:48 AM »
What makes this mod here differently than like this?
http://www.4homepages.de/forum/index.php?topic=6729.0
Here is this better or is that whatever you take?

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: [MOD] Google Friendly Urls For 4images Best Seo Mod
« Reply #152 on: October 27, 2008, 08:27:56 AM »
The author of this mod went an "easy" way by adding additional database query requests for each link to an image or category. It made the mod more universal with less changes in the code, but which creates more server load.
« Last Edit: October 27, 2008, 09:08:07 AM by V@no »
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline Sunny C.

  • Addicted member
  • ******
  • Posts: 1.805
  • I ♥ 4I
    • View Profile
Re: [MOD] Google Friendly Urls For 4images Best Seo Mod
« Reply #153 on: October 27, 2008, 08:46:01 AM »
ok, thank you!

Offline nic_bck

  • Newbie
  • *
  • Posts: 29
    • View Profile
Re: [MOD] Google Friendly Urls For 4images Best Seo Mod
« Reply #154 on: November 01, 2008, 02:44:31 AM »
Hello guys!  Sorry for my English :P

Please, I need your help!

I want to use this mod, but I want to have the URLs like this:

Code: [Select]
http://www.misite.com/4images/cat-[CATEGORY_NAME]-[CATEGORY_ID].htm
http://www.misite.com/4images/img-[IMAGE_NAME]-[IMAGE_ID].htm

But this mod do this kind of URL:

Code: [Select]
http://www.misite.com/4images/cat[CATEGORY_ID]..htm
http://www.misite.com/4images/img[IMAGE_ID].htm

This other mod do the kind of URL what I want:
[MOD] Google Friendly Urls For 4images Best Seo Mod

BUT, like V@no said:
Quote
The author of this mod went an "easy" way by adding additional database query requests for each link to an image or category. It made the mod more universal with less changes in the code, but which creates more server load.

That mod do a lot of querys, and do it more than one time  8O
Like this:

Code: [Select]
SELECT cat_id,image_name FROM 4images_images WHERE image_id = '5683'
Querytime: 0

SELECT cat_id,image_name FROM 4images_images WHERE image_id = '5683'
Querytime: 0

SELECT cat_id,image_name FROM 4images_images WHERE image_id = '5683'
Querytime: 0

SELECT cat_id,image_name FROM 4images_images WHERE image_id = '5683'
Querytime: 0

SELECT cat_id,image_name FROM 4images_images WHERE image_id = '5683'
Querytime: 0

SELECT sessionvars_value FROM 4images_sessionvars WHERE sessionvars_name = 'download_token' AND session_id = '0132b7f63b60ad312cd8afb82d69e221'
Querytime: 0.002

SELECT cat_id,image_name FROM 4images_images WHERE image_id = '6813'
Querytime: 0

SELECT cat_id,image_name FROM 4images_images WHERE image_id = '6813'
Querytime: 0

SELECT cat_name,cat_parent_id FROM 4images_categories WHERE cat_id = '148'
Querytime: 0

SELECT cat_id,image_name FROM 4images_images WHERE image_id = '6813'
Querytime: 0

SELECT cat_id,image_name FROM 4images_images WHERE image_id = '6813'
Querytime: 0

SELECT cat_id,image_name FROM 4images_images WHERE image_id = '6813'
Querytime: 0

SELECT cat_id,image_name FROM 4images_images WHERE image_id = '6813'
Querytime: 0

SELECT cat_id,image_name FROM 4images_images WHERE image_id = '6813'
Querytime: 0

SELECT cat_id,image_name FROM 4images_images WHERE image_id = '6813'

Examples:

With this mod, category page load:
Code: [Select]
Page generated in 0.739813 seconds with 23 queries, spending 0.427000 seconds doing MySQL queries and 0.312813 doing PHP things. GZIP compression disabled
With the other mod ([MOD] Google Friendly Urls For 4images Best Seo Mod), category page load::
Code: [Select]
Page generated in 1.061930 seconds with 134 queries, spending 0.715000 seconds doing MySQL queries and 0.346930 doing PHP things. GZIP compression disabled
With this mod, details page load:
Code: [Select]
Page generated in 0.665015 seconds with 15 queries, spending 0.368000 seconds doing MySQL queries and 0.297015 doing PHP things. GZIP compression disabled
With the other mod ([MOD] Google Friendly Urls For 4images Best Seo Mod), details page load::
Code: [Select]
Page generated in 0.713163 seconds with 39 queries, spending 0.393000 seconds doing MySQL queries and 0.320163 doing PHP things. GZIP compression disabled
Please I need help to do a "hybrid", I want to have this good mod but with the name of the category or the name of the image into the URL.

Please help me, I think that it would be very interesting for a lot of people.

I'm trying to do it :P

Thanks!


Offline Nicky

  • Administrator
  • 4images Guru
  • *****
  • Posts: 3.195
    • View Profile
Re: [MOD] Google Friendly Urls For 4images Best Seo Mod
« Reply #155 on: November 01, 2008, 11:52:40 AM »
h nic_bck,

okay do it :)

just for your info:

i have this stats in another mod - [MOD] Google Friendly Urls For 4images Best Seo Mod

index site
Code: [Select]
Page generated in 0.392127 seconds with 120 queries, spending 0.228000 seconds doing MySQL queries and 0.164127 doing PHP things. GZIP compression enabled
category site (most subcategories)
Code: [Select]
Page generated in 0.690441 seconds with 1183 queries, spending 0.052000 seconds doing MySQL queries and 0.638441 doing PHP things. GZIP compression enabled
details site
Code: [Select]
Page generated in 0.152386 seconds with 21 queries, spending 0.054000 seconds doing MySQL queries and 0.098386 doing PHP things. GZIP compression enabled
hope you can make it better
cheers
Nicky
Your first three "must do" before you ask a question ! (© by V@no)
- please read the Forum Rules ...
- please study the FAQ ...
- please try to Search for your answer ...

nicky.net 4 4images
Signature stolen from mawenzi

Offline nic_bck

  • Newbie
  • *
  • Posts: 29
    • View Profile
Re: [MOD] Google Friendly Urls For 4images Best Seo Mod
« Reply #156 on: November 01, 2008, 02:36:41 PM »
Hi Nicky and friends!! First Sorry for my English :P

I have my first improve to the mod: [MOD] Google Friendly Urls For 4images Best Seo Mod, this modification avoid duplicate queries.

Examples:

With the mod ([MOD] Google Friendly Urls For 4images Best Seo Mod), category page load:
Code: [Select]
Page generated in 1.061930 seconds with 134 queries, spending 0.715000 seconds doing MySQL queries and 0.346930 doing PHP things. GZIP compression disabled
With the mod ([MOD] Google Friendly Urls For 4images Best Seo Mod) with my improve, category page load:
Code: [Select]
Page generated in 0.697700 seconds with 38 queries, spending 0.362000 seconds doing MySQL queries and 0.335700 doing PHP things. GZIP compression disabled
With the mod ([MOD] Google Friendly Urls For 4images Best Seo Mod), details page load:
Code: [Select]
Page generated in 0.713163 seconds with 39 queries, spending 0.393000 seconds doing MySQL queries and 0.320163 doing PHP things. GZIP compression disabled
With the mod ([MOD] Google Friendly Urls For 4images Best Seo Mod) with my improve, details page load:
Code: [Select]
Page generated in 0.654014 seconds with 22 queries, spending 0.349000 seconds doing MySQL queries and 0.305014 doing PHP things. GZIP compression disabled
The modification:
NOTE: This is a improve of  [MOD] Google Friendly Urls For 4images Best Seo Mod so you have to have it installed :P

Step 1
Open /includes/sessions.php
Find:
Code: [Select]
//Mod_bmollet
/**
 * Get the category url
 * @param int $cat_id The id of the category
 * @param string $cat_url The current status of the URL
 */
function get_category_url($cat_id,$cat_url = '')
{
global $site_db;
$sql = "SELECT cat_name,cat_parent_id FROM ".CATEGORIES_TABLE." WHERE cat_id = '".$cat_id."'";
$result = $site_db->query($sql);
$row = $site_db->fetch_array($result);
$row['cat_name'] = strtr($row['cat_name'], "éèêàëâúóíáABCDEFGHIJKLMNOPQRSTUVWXYZ","eeeaeauoiaabcdefghijklmnopqrstuvwxyz");
$cat_url  = '-'.str_replace('+','-',urlencode($row['cat_name'])).'-'.$cat_id.$cat_url;
// if you want full path of category in url, put next line in comment
return $cat_url;
if( $row['cat_parent_id'] != 0)
{
return get_category_url($row['cat_parent_id'],$cat_url);
}
else
{
return $cat_url;
}
}
//Mod_bmollet
/**
 * Get the image url
 * @param int $image_id The id of the image
 */
function get_image_url($image_id)
{
global $site_db;
$sql = "SELECT cat_id,image_name FROM ".IMAGES_TABLE." WHERE image_id = '".$image_id."'";
$result = $site_db->query($sql);
$row = $site_db->fetch_array($result);
$row['image_name'] = strtr($row['image_name'], "éèêàëâúóíáABCDEFGHIJKLMNOPQRSTUVWXYZ","eeeaeauoiaabcdefghijklmnopqrstuvwxyz");
// if you want comlpete path to image in url, remove comment from following line
//return get_category_url($row['cat_id']).'-'.str_replace('+','-',urlencode($row['image_name'])).'-'.$image_id;
return '-'.str_replace('+','-',urlencode($row['image_name'])).'-'.$image_id;
}

Replace with:

Code: [Select]
//Mod_bmollet && improve by nic_bck v0.1
/**
 * Get the category url
 * @param int $cat_id The id of the category
 * @param string $cat_url The current status of the URL
 */
$categoria_anterior;
$url_categoria_anterior;
function get_category_url($cat_id,$cat_url = '')
{
global $site_db;
global $categoria_anterior;
global $url_categoria_anterior;
if ($categoria_anterior == $cat_id)
{
return $url_categoria_anterior;
}
$sql = "SELECT cat_name,cat_parent_id FROM ".CATEGORIES_TABLE." WHERE cat_id = '".$cat_id."'";
$result = $site_db->query($sql);
$row = $site_db->fetch_array($result);
$row['cat_name'] = strtr($row['cat_name'], "éèêàëâúóíáABCDEFGHIJKLMNOPQRSTUVWXYZ","eeeaeauoiaabcdefghijklmnopqrstuvwxyz");
$cat_url  = '-'.str_replace('+','-',urlencode($row['cat_name'])).'-'.$cat_id.$cat_url;
// if you want full path of category in url, put next line in comment
$categoria_anterior = $cat_id;
$url_categoria_anterior = $cat_url;
return $cat_url;
if( $row['cat_parent_id'] != 0)
{
return get_category_url($row['cat_parent_id'],$cat_url);
}
else
{
return $cat_url;
}
}
//Mod_bmollet && improve by nic_bck v0.1
/**
 * Get the image url
 * @param int $image_id The id of the image
 */
$imagen_anterior;
$url_imagen_anterior;
function get_image_url($image_id)
{
global $site_db;
global $imagen_anterior;
global $url_imagen_anterior;
//echo "imagen: " . $imagen_anterior;
if ($imagen_anterior == $image_id)
{
return $url_imagen_anterior;
}
$sql = "SELECT cat_id,image_name FROM ".IMAGES_TABLE." WHERE image_id = '".$image_id."'";
$result = $site_db->query($sql);
$row = $site_db->fetch_array($result);
$row['image_name'] = strtr($row['image_name'], "éèêàëâúóíáABCDEFGHIJKLMNOPQRSTUVWXYZ","eeeaeauoiaabcdefghijklmnopqrstuvwxyz");
// if you want comlpete path to image in url, remove comment from following line
//return get_category_url($row['cat_id']).'-'.str_replace('+','-',urlencode($row['image_name'])).'-'.$image_id;
       $imagen_anterior = $image_id;
$url_imagen_anterior = '-'.str_replace('+','-',urlencode($row['image_name'])).'-'.$image_id;
return '-'.str_replace('+','-',urlencode($row['image_name'])).'-'.$image_id;

}

Please, Nicky test it!!! and put here your new stats.

I'm trying to improve it with a better version.

Thanks!

Offline Nicky

  • Administrator
  • 4images Guru
  • *****
  • Posts: 3.195
    • View Profile
Re: [MOD] Google Friendly Urls For 4images Best Seo Mod
« Reply #157 on: November 01, 2008, 05:14:44 PM »
hi nic,

okay, i added our post#s to the correct thread..
i will test it in few minutes.

btw. your english is okay ;)
cheers
Nicky
Your first three "must do" before you ask a question ! (© by V@no)
- please read the Forum Rules ...
- please study the FAQ ...
- please try to Search for your answer ...

nicky.net 4 4images
Signature stolen from mawenzi

Offline Nicky

  • Administrator
  • 4images Guru
  • *****
  • Posts: 3.195
    • View Profile
Re: [MOD] Google Friendly Urls For 4images Best Seo Mod
« Reply #158 on: November 01, 2008, 05:39:54 PM »
okay,

here we go

index site
Code: [Select]
Page generated in 0.395708 seconds with 76 queries, spending 0.232000 seconds doing MySQL queries and 0.163708 doing PHP things. GZIP compression enabled
category site (most subs)
Code: [Select]
Page generated in 0.680518 seconds with 596 queries, spending 0.055000 seconds doing MySQL queries and 0.625518 doing PHP things. GZIP compression enabled
details site
Code: [Select]
Page generated in 0.158879 seconds with 16 queries, spending 0.054000 seconds doing MySQL queries and 0.104879 doing PHP things. GZIP compression enabled
yep..
index and categories queries are down up to 50%

GREAT! Thank you 4 that!
« Last Edit: November 01, 2008, 06:10:42 PM by Nicky »
cheers
Nicky
Your first three "must do" before you ask a question ! (© by V@no)
- please read the Forum Rules ...
- please study the FAQ ...
- please try to Search for your answer ...

nicky.net 4 4images
Signature stolen from mawenzi

Offline nic_bck

  • Newbie
  • *
  • Posts: 29
    • View Profile
Re: [MOD] Google Friendly Urls For 4images Best Seo Mod
« Reply #159 on: November 01, 2008, 08:10:00 PM »
okay,

here we go

index site
Code: [Select]
Page generated in 0.395708 seconds with 76 queries, spending 0.232000 seconds doing MySQL queries and 0.163708 doing PHP things. GZIP compression enabled
category site (most subs)
Code: [Select]
Page generated in 0.680518 seconds with 596 queries, spending 0.055000 seconds doing MySQL queries and 0.625518 doing PHP things. GZIP compression enabled
details site
Code: [Select]
Page generated in 0.158879 seconds with 16 queries, spending 0.054000 seconds doing MySQL queries and 0.104879 doing PHP things. GZIP compression enabled
yep..
index and categories queries are down up to 50%

GREAT! Thank you 4 that!

Hi! Nicky. It works! I'm very happy :P

I'll try to make it better, but I don't have free time now. :(

Thanks for test it!

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: [MOD] Google Friendly Urls For 4images Best Seo Mod
« Reply #160 on: November 01, 2008, 09:17:31 PM »
Since we are on optimizing rage today, little more optimized nic_bck's version:

Code: [Select]
function fixname($text)
{
  return strtolower(strtr(
    $text,
     array(
      "é" => "e",
      "è" => "e",
      "ê" => "e",
      "à" => "a",
      "ë" => "e",
      "â" => "a",
      "ú" => "a",
      "ó" => "o",
      "í" => "i",
      "á" => "a",

      //russian UTF8 encoded alphabet (lower and upper cases)
      "А" => "a",
      "а" => "a",
      "Б" => "b",
      "б" => "b",
      "В" => "v",
      "в" => "v",
      "Г" => "g",
      "г" => "g",
      "Д" => "d",
      "д" => "d",
      "Е" => "e",
      "е" => "e",
      "Ё" => "yo",
      "ё" => "yo",
      "Ж" => "zh",
      "ж" => "zh",
      "З" => "z",
      "з" => "z",
      "И" => "i",
      "и" => "i",
      "Й" => "j",
      "й" => "j",
      "К" => "k",
      "к" => "k",
      "Л" => "l",
      "л" => "l",
      "М" => "m",
      "м" => "m",
      "Н" => "n",
      "н" => "n",
      "О" => "o",
      "о" => "o",
      "П" => "p",
      "п" => "p",
      "Р" => "r",
      "р" => "r",
      "С" => "s",
      "с" => "s",
      "Т" => "t",
      "т" => "t",
      "У" => "u",
      "у" => "u",
      "Ф" => "f",
      "ф" => "f",
      "Х" => "h",
      "х" => "h",
      "Ц" => "c",
      "ц" => "c",
      "Ч" => "ch",
      "ч" => "ch",
      "Ш" => "sh",
      "ш" => "sh",
      "Щ" => "sch",
      "щ" => "sch",
      "Ъ" => "",
      "ъ" => "",
      "Ы" => "i",
      "ы" => "i",
      "Ь" => "'",
      "ь" => "'",
      "Э" => "e",
      "э" => "e",
      "Ю" => "yu",
      "ю" => "yu",
      "Я" => "ya",
      "я" => "ya",
  )));
}
function get_category_url($cat_id,$cat_url = '')
{
  global $site_db, $cat_cache;
  static $urlname = array(); //cache names in this array
  if (isset($urlname[$cat_id]))
    return $urlname[$cat_id];
  if (!empty($cat_cache))
  {
    $row['cat_name'] = @$cat_cache[$cat_id]['cat_name'];
    $row['cat_parent_id'] = @$cat_cache[$cat_id]['cat_parent_id'];
  }
  else
  {
    $sql = "SELECT cat_name,cat_parent_id FROM ".CATEGORIES_TABLE." WHERE cat_id = '".$cat_id."'";
    $row = $site_db->query_firstrow($sql);
  }
  $row['cat_name'] = fixname($row['cat_name']);
  $cat_url  = '-'.str_replace('+','-',urlencode($row['cat_name'])).'-'.$cat_id.$cat_url;
  // if you want full path of category in url, put next line in comment
  $row['cat_parent_id'] = 0;
  if($row['cat_parent_id'] != 0)
  {
    $urlname[$cat_id] = get_category_url($row['cat_parent_id'],$cat_url);
  }
  else
  {
    $urlname[$cat_id] = $cat_url;
  }
  return $urlname[$cat_id];
}
//Mod_bmollet
/**
 * Get the image url
 * @param int $image_id The id of the image
 */
function get_image_url($image_id)
{
  global $site_db;
  static $urlname = array(); //cache names in this array
  if (isset($urlname[$image_id]))
    return $urlname[$image_id];
 
  $sql = "SELECT cat_id,image_name FROM ".IMAGES_TABLE." WHERE image_id = '".$image_id."'";
  $row = $site_db->query_firstrow($sql);
  $row['image_name'] = fixname($row['image_name']);
  // if you want comlpete path to image in url, remove comment from following line
  //$urlname[$image_id] = get_category_url($row['cat_id']).'-'.str_replace('+','-',urlencode($row['image_name'])).'-'.$image_id; 
  $urlname[$image_id] = '-'.str_replace('+','-',urlencode($row['image_name'])).'-'.$image_id;
  return $urlname[$image_id];
}


Results:

index.php
Original
Code: [Select]
Page generated in 0.109686 seconds with 36 queries, spending 0.059000 seconds doing MySQL queries and 0.050686 doing PHP things. GZIP compression disabledOptimized
Code: [Select]
Page generated in 0.095068 seconds with 11 queries, spending 0.059000 seconds doing MySQL queries and 0.036068 doing PHP things. GZIP compression disabled
categories.php (30 images per page)
Original:
Code: [Select]
Page generated in 0.227558 seconds with 195 queries, spending 0.051000 seconds doing MySQL queries and 0.176558 doing PHP things. GZIP compression disabledOptimized:
Code: [Select]
Page generated in 0.179981 seconds with 37 queries, spending 0.050000 seconds doing MySQL queries and 0.129981 doing PHP things. GZIP compression disabled
details.php
Original
Code: [Select]
Page generated in 0.219341 seconds with 22 queries, spending 0.110000 seconds doing MySQL queries and 0.109341 doing PHP things. GZIP compression disabledOptimized
Code: [Select]
Page generated in 0.060998 seconds with 14 queries, spending 0.028000 seconds doing MySQL queries and 0.032998 doing PHP things. GZIP compression disabled
« Last Edit: July 03, 2010, 10:15:08 PM by V@no »
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline Nicky

  • Administrator
  • 4images Guru
  • *****
  • Posts: 3.195
    • View Profile
Re: [MOD] Google Friendly Urls For 4images Best Seo Mod
« Reply #161 on: November 01, 2008, 09:33:55 PM »
PERFECT!

index.php
Code: [Select]
Page generated in 0.194642 seconds with 27 queries, spending 0.044000 seconds doing MySQL queries and 0.150642 doing PHP things. GZIP compression enabled
categories.php with most subcategories
Code: [Select]
Page generated in 0.607308 seconds with 8 queries, spending 0.045000 seconds doing MySQL queries and 0.562308 doing PHP things. GZIP compression enabled
categories.php with 30 images per page
Code: [Select]
Page generated in 0.263828 seconds with 98 queries, spending 0.046000 seconds doing MySQL queries and 0.217828 doing PHP things. GZIP compression enabled
details.php
Code: [Select]
Page generated in 0.209541 seconds with 15 queries, spending 0.112000 seconds doing MySQL queries and 0.097541 doing PHP things. GZIP compression enabled
LOL.. i turned off GZIP compression................................................
2-4 seconds building...
cheers
Nicky
Your first three "must do" before you ask a question ! (© by V@no)
- please read the Forum Rules ...
- please study the FAQ ...
- please try to Search for your answer ...

nicky.net 4 4images
Signature stolen from mawenzi

Offline nic_bck

  • Newbie
  • *
  • Posts: 29
    • View Profile
Re: [MOD] Google Friendly Urls For 4images Best Seo Mod
« Reply #162 on: November 02, 2008, 03:01:34 PM »
Thanks V@no!!

Good work!

One question: what is better? GZIP enable or disable?

Thanks!


Offline batu544

  • Sr. Member
  • ****
  • Posts: 336
    • View Profile
    • Free Celebrity wallpapers
Re: [MOD] Google Friendly Urls For 4images Best Seo Mod
« Reply #163 on: November 05, 2008, 08:34:36 PM »
V@no,
              Is your optimized code works for english  version. ?


FYI,
       I just tried the changed code on my local system.. here is the result..

For index page only ( before change)
Code: [Select]
Page generated in 0.466600 seconds with 67 queries, spending 0.215000 seconds doing MySQL queries and 0.251600 doing PHP things. GZIP compression disabled
Page generated in 0.409851 seconds with 67 queries, spending 0.222000 seconds doing MySQL queries and 0.187851 doing PHP things. GZIP compression disabled
Page generated in 0.459074 seconds with 67 queries, spending 0.215000 seconds doing MySQL queries and 0.244074 doing PHP things. GZIP compression disabled
Page generated in 0.468307 seconds with 70 queries, spending 0.225000 seconds doing MySQL queries and 0.243307 doing PHP things. GZIP compression disabled
Page generated in 0.462290 seconds with 67 queries, spending 0.215000 seconds doing MySQL queries and 0.247290 doing PHP things. GZIP compression disabled
Page generated in 0.481106 seconds with 67 queries, spending 0.223000 seconds doing MySQL queries and 0.258106 doing PHP things. GZIP compression disabled
Page generated in 0.450743 seconds with 67 queries, spending 0.212000 seconds doing MySQL queries and 0.238743 doing PHP things. GZIP compression disabled
Page generated in 0.461674 seconds with 67 queries, spending 0.220000 seconds doing MySQL queries and 0.241674 doing PHP things. GZIP compression disabled



After change

Code: [Select]
Page generated in 0.493634 seconds with 22 queries, spending 0.272000 seconds doing MySQL queries and 0.221634 doing PHP things. GZIP compression disabled
Page generated in 0.449397 seconds with 19 queries, spending 0.214000 seconds doing MySQL queries and 0.235397 doing PHP things. GZIP compression disabled
Page generated in 0.445229 seconds with 19 queries, spending 0.217000 seconds doing MySQL queries and 0.228229 doing PHP things. GZIP compression disabled
Page generated in 0.445182 seconds with 19 queries, spending 0.215000 seconds doing MySQL queries and 0.230182 doing PHP things. GZIP compression disabled
Page generated in 0.461345 seconds with 19 queries, spending 0.224000 seconds doing MySQL queries and 0.237345 doing PHP things. GZIP compression disabled
Page generated in 0.445921 seconds with 19 queries, spending 0.216000 seconds doing MySQL queries and 0.229921 doing PHP things. GZIP compression disabled
Page generated in 0.468698 seconds with 22 queries, spending 0.221000 seconds doing MySQL queries and 0.247698 doing PHP things. GZIP compression disabled



I can see only the number of queries has decreased .. not the total time of page generation..  :)


Thanks
« Last Edit: November 05, 2008, 09:01:26 PM by batu544 »

Offline V@nо

  • Addicted member
  • ******
  • Posts: 1.223
    • View Profile
Re: [MOD] Google Friendly Urls For 4images Best Seo Mod
« Reply #164 on: November 05, 2008, 09:03:41 PM »
yes, english names don't need any conversion, they will be used as they are
Your first three "must do" before you ask a question:
If I asked you to PM me, I meant PM to my primary account, this account doesn't accept PMs.