Using memkesh

Question

This is how my information is displayed

$count = mysql_result(mysql_query('SELECT COUNT(*) FROM `blog`'), 0); if ($count > 0) { $req = mysql_query("SELECT * FROM `blog` ORDER BY `id` DESC LIMIT " . $start . "," . $message); while ($row = mysql_fetch_assoc($req)) { echo '<b>'.$row['name'].'</b> '.times($row['time']).'<br/>'; if (mb_strlen($row['text']) > 149) { $text = mb_substr($row['text'], 0, 149); echo ''.$text.'...'; } else { echo $row['text']; } echo '<br/><a href="'.$home.'/admin/blog.php?view&amp;id='.$row['id'].'">подробнее</a><br/> <a href="'.$home.'/admin/blog.php?edit&amp;id='.$row['id'].'"><input type="submit" value="редактировать запись"/></a> <a href="'.$home.'/admin/blog.php?del&amp;id='.$row['id'].'"><input type="submit" value="удалить запись"/></a> <div id="hr"></div>'; } if ($count > $message) { echo ''.pagenav('?', $start, $count, $message); } } else { echo 'Записи еще не созданы!'; }

And how to make the output of information using memkes? For information to be cached, say, for half an hour.

For the future - format the code, please, otherwise nothing is visible in this jumble.

Answer 1 · 2012-05-03T21:58:55

 // какой мемкеш используете непринципиально, // чуть отличаются параметры, принцип тот же остается. // Memcached чуть медленнее Memcache в синтетических тестах $memcache = new Memcached(); // интервал кэширования $cache_interval = 1800; //соединяемся $memcache->addServer('localhost', 11211) or die ("Could not connect to memcached"); //первый запрос $query = 'SELECT COUNT(*) FROM `blog`'; //ключ, по которому будем искать этот запрос в мемкеше $key = "blog_count"; $count = $memcache->get($key); if($count === false) { // не нашли в мемкеше, берем из базы $count = mysql_result(mysql_query($query), 0); //складываем в мемкеш $memcache->set($key,$result,$cache_interval); } if($count>0) { // второй запрос $query = "SELECT * FROM `blog` ORDER BY `id` DESC LIMIT " . $start . "," . $message; // ключ для мемкеша этого запроса $key = md5('query'.$query); //ищем в мемкеше этот запрос $rows = $memcache->get($key); // нашли? if ($rows === false) { // не нашли, читаем из базы в массив $rows $rows = array(); $req = mysql_query($query); while ($row = mysql_fetch_assoc($req)) { $rows[] = $rec; } // пишем в мемкеш $memcache->set($key, $rows, $cache_interval); } // работаем с массивом как раньше foreach($rows as $row) { // используем $row как раньше... ...

Threat wrote in the answer window, errors are possible

And who and how dumps memcache when changing data in the blog table?
Yes, you can change the cache with changes, but it seems that half an hour the weather does not.
Judging by the initial question and talking about half an hour, the vehicle apparently understands that the changes will be frozen for half an hour for visitors who are ridonly.
For authors of the blog who want to make any changes, this approach is naturally not suitable.
those who can change the content either have to work directly with the database (without the cache), or have to modify the cache for each update or delete in the database.
the fact that the records are not displayed is already a result, you need to watch what happens at each stage (connection, het, set ...)

drdaeman drdaeman 8,605 14 35 · Answer 2 · 2012-05-03T21:25:02

In Hindu - for example, like this:

 $mc = new Memcache; $mc->connect(...); ... $key = "blog/by-id[$start,$message]"; $html = $mc->get($key); if ($html === false) { ob_start(); $req = mysql_query("SELECT * FROM `blog` ORDER BY `id` DESC LIMIT " . $start . "," . $message); while ($row = mysql_fetch_assoc($req)) { // ... } $html = ob_end_clean(); $mc->set($key, $html); }

But this is not a code, but rubbish.

In the mind - to spread the model and the view, the fragment cache to implement at the template level, the data cache - at the model level (mixin or decorator). In order not to reinvent the wheel, take a ready-made framework that will do everything on its own.

Thanks for answers. For example, what kind of framework? - vitagame

Using memkesh

2 answers 2

More articles: