.. You may want to use the usual include line. Uncomment and adjust the path. 
.. include:: ../Includes.txt


================
EXT: bk\_realulr
================

:Author:
      Robert Lemke

:Created:
      2005-05-31T11:13:57

:Changed:
      2005-11-09T09:20:44

:Email:
      contact@brikou.com

:Info 2:


:Info 3:


:Info 4:


.. _EXT-bk-realulr:

EXT: bk\_realulr
================

Extension Key:  **bk\_realurl**

Copyright 2000-2005, contact@brikou.com, <contact@brikou.com>

This document is published under the Open Content License

available from http://www.opencontent.org/opl.shtml

The content of this document is related to TYPO3

\- a GNU/GPL CMS/Framework available from www.typo3.com

.. _Table-of-Contents:

Table of Contents
-----------------

**EXT: bk\_realulr 1**

**Introduction 1**

What does it do? 1

Screenshots 1

**Users manual 1**

Logging slow queries with MySQL 1

Example of what you may find 1

Another example of slow querie 2

**Administration 2**

**Configuration 2**

**Known problems 2**

**To-Do list 2**

**Changelog 2**


.. _Introduction:

Introduction
------------


.. _What-does-it-do:

What does it do?
^^^^^^^^^^^^^^^^

RealURL is a great extension, but when you deal with big website
(hundreds or thousand pages generated like `www.lyrics-of.com
<../../TheProject/doc/www.lyrics-of.com>`_ ) you can face the problem
of slow queries. So this extension extends 'RealURL' in order to
accelerate MySQL by adjusting table structure. This extension works
with RealURL 1.0.0. and be aware that alias is now limited to 255
characters.

In the case study of this famous `lyrics website <http://www.lyrics-
of.com/>`_ the time saved was about 60-80%. You are invited to give
feedback (in “user annotations” section) about your website size and
the gain you've made using this extension.


.. _Screenshots:

Screenshots
^^^^^^^^^^^

What is done during installation :

|img-1|


.. _Users-manual:

Users manual
------------


.. _Logging-slow-queries-with-MySQL:

Logging slow queries with MySQL
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

If you're not sure that your slow problem comes from RealURL, you can
try amphisize slo queries by adjusting your MySQL configuration file
'my.cnf' by adding these lines (self explicit I guess):

log-slow-queries=/var/log/mysqld/mysqld-slow.loglog-long-formatlong-
query-time=1


.. _Example-of-what-you-may-find:

Example of what you may find
^^^^^^^^^^^^^^^^^^^^^^^^^^^^

\# Time: 051108 21:50:05# User@Host: root[root] @ localhost []#
Query\_time: 2 Lock\_time: 0 Rows\_sent: 0 Rows\_examined: 314085

SELECT value\_aliasFROM tx\_realurl\_uniqaliasWHEREvalue\_id=''AND
field\_alias='title'AND field\_id='uid'AND
tablename='tx\_myextension'AND lang=0AND expire=0;


.. _Another-example-of-slow-querie:

Another example of slow querie
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

\# Time: 051108 23:15:39# User@Host: root[root] @ localhost []#
Query\_time: 2 Lock\_time: 0 Rows\_sent: 0 Rows\_examined: 314085

SELECT value\_idFROM tx\_realurl\_uniqaliasWHEREvalue\_alias=''AND
field\_alias='title'AND field\_id='uid'AND
tablename='tx\_myextension'AND (expire=0 OR expire>1131488137);


.. _Administration:

Administration
--------------

There's nothing to do because this extension manage only a database
update...


.. _Configuration:

Configuration
-------------

No configuration is required.


.. _Known-problems:

Known problems
--------------

Because of database index generation, we have to specify the maximum
length of blob values. This means that uniqalias are now limited
(truncated during update) to the maximum of 255 characters (enough for
most case).


.. _To-Do-list:

To-Do list
----------

Nothing to be done or maybe I'm wrong, contact me if you wish or visit
my website : `www.brikou.com <http://www.brikou.com/>`_ and leave me a
comment in my guestbook.


.. _Changelog:

Changelog
---------

1.0.0 – First public release : ALTERATION of table
tx\_realurl\_uniqalias in order to add 2 usefull KEYs

|img-2| EXT: bk\_realulr - 2


.. ######CUTTER_MARK_IMAGES######

.. |img-1| image:: img-1.png
.. :align: left
.. :border: 0
.. :height: 18%
.. :id: Image1
.. :name: Image1
.. :width: 100%

.. |img-2| image:: img-2.png
.. :align: left
.. :border: 0
.. :height: 32
.. :id: Graphic1
.. :name: Graphic1
.. :width: 102