На страницах этого блога уже было описано применение технологии memcache для кеширования веб страниц целиком. действительно, это очень удобная технология позволяет делать это очень быстро и надежно, при этом нет необходимости держать огромную папку закешированного содержимого. Все лежит в оперативной памяти.

Конечно, если памяти доступной для этого расширения не достаточно, то тут ничего не сделаешь. Но для выделенных сервером, как было в моем случае, это не проблема.

В этой статье я расскажу, как закешировать sql запросы к базе данных. 

В любой нормальной системе, будь то CMS или фреймворк, есть срипт, который отвечает за запросы к базе данных. Мало кто из программистов в наше время пишет 

mysql_query('select * from tablename')

всегда есть некая прослойка. Если ее нет, то ее не сложно написать. В этой статье я буду ускорять CMS Joomla и при этом буду использовать свою   прослойку uno, которая в свою очередь является прослойкой над Joomla прослойкой над PDO интерфейсом. Вот такие хитросплетения. 

В uno есть несколько методов для выборки данных: getRows,getRows,count, getRowsBySQL,exists,getRowsBySQL

Вот их и нужно кешировать. Для этого в каждый метод, необходимо добавить параметр: $usecache = false. Далее, напишу, как это работает на примере только getRow. Предполагается, что у вас уже есть класс для работы с memcahe

static public function getRow($table,$conditions=false,$colums=array('*'),$order = false,$offset = 0, $usecache = false){
	$key = md5(serialize(array($table,$conditions,$colums,$order,$offset)));
	if( $usecache and $result = mem::gi()->get($key))
		return $result;
	$result = self::query($table,$conditions,$colums,$order,1,$offset)->loadAssoc();
	if( $usecache!==false ){
		mem::gi()->set($key,$result,$usecache);
	}	
	return $result;
}

 При использовании метода, в параметр   $usecache, нужно подать количество секунд для хранения данных в memcache, по истечении которых, кеш нужно будет обновить. 

В статичных сайтах, этим значением может быть очень больше число. Если сайт создан исключительно для продажи контекстной рекламы Google (Гугл), и представляет собой множество интересных постов, то там можно кешировать и при помощи файлов.   

Но для динамичных порталов, в которых такое кеширование и имеет смысл делать, нужно предусмотреть обновление кеша. 

К примеру, пользователь зарегистрировался. После этого, список ранее закешированных пользователей нужно обновить. Для этого в $usememcache нужно подать 0. Тогда кеш затрется. 

Рассказать друзьям
author.jpg

Платная консультация по вопросам 2500 руб/час

Прочитали статью и остались вопросы? Меня зовут Валерий и я её автор. С радостью объясню Вам в скайпе все затруднительные моменты, которые остались за рамками статьи!

Подробнее ...

Добавить комментарий


Комментарии   

Sfera1
+1 # Sfera1 03.03.2015 00:07
Чудно написано, но только вообще ничего не понятно.
По этому и не нужно.
Ответить | Ответить с цитатой | Цитировать | Сообщить модератору
venture capitalist
0 # venture capitalist 03.09.2021 00:26
Later they can play an critical role in the process oof "going public" by advising on the
terms and price tagg of public challenges aand by arranging underwriting
when required. A VC fiirm does not need to have
plenty of juniors to do monetary analysis hence, they ddo not have a regular recruitment timeline and procedure.
If you are familiar with PE recruitment, VC one is rather the similar as a PE’s
off-cycle recruitment. Due to the similarity in theirr
concept, they aare taken as a single and the
same thing. venture capitalist Capital Analyst and especially Venture Capital Associate are open to
newcomers of this market. Above: Nvidia’s Inception AI
startups by industry. But it’s also a sales profession where you compete
for capital and access to the most effective startups.
With Venture Capital, commence-ups can access the capital market
place in their early stages and without having a lot tough assets.
3. Typically, angels invest in the early stages of a small business and nurture/challenge/mentor the founder and group
to find item-industry match. We’re in the enterprise
of locating the ideal fit of alpha producing prospective,
in the context of massive bets in venture and impact and seriously understanding trends that
drive that probability of great achievement.
Late-stage life science VC funds tend to care a lot
more about finance expertise, so if you’re extra of a finance
individual with some information of science, late-stage funds may
well be a far better fit.
Ответить | Ответить с цитатой | Цитировать | Сообщить модератору
venture capital
0 # venture capital 03.09.2021 18:58
Peters himself has stated that Schawbel "has taken individual branding to a dimension a million miles beyond exactly where I was." Schawbel
credits the technologies that have grow to bee readily available considering the fact that Peters' heyday.
In (7-3), boards perr basdic partner iis made use of as an alternative measure of VC resourcess
and is meant to capture the available time that partners in VC firms may wdll have offered in mentoring, building, and connecting start-ups.
At a time when innovation is at an all time higher, and when entrepreneurs thought they had it tough to convincxe
a venture fund to finance their startup, items arre
going to get a entire lot tougher. Also, when approaching for venture capital funding, there are three most
essential items that have to be taken care
of - study, attitude and network. "If a excellent entrepreneur is pursuing something that is a undesirable notion, you don’t want to tie up $10 million and three years of their life," says Bussgang.
You almost certainly currently have a good instinctive feel for
your business, but the challenge when dealing with VCs
is getting in a position to succinctly articulate this.
Ответить | Ответить с цитатой | Цитировать | Сообщить модератору
venture capitalist
0 # venture capitalist 04.09.2021 16:43
VentureOnee Corporation. "1998 Investment Highlights." Industry Data.
This investigation updates earlier study by the Diana Project using a
data base of all venture capital funded firms in the US.
At its peak, SoftBaank took this global concept a single step further,
utilizing its first Vision Fund’s $100 billion war chest to invest in rivals in the very same sector - and forcing
them into arranged marriages. Dont commingle funds. Avoid falling into
thhe trap of employing new funds to level the books.

The firm had published many books aand totally ffree references on startups
and VC investing, and I read alll of them and prepared a few ideas for additional chapters and examples
that could be helpful. Download the comon term sheet from Y
Combinator andd 500 Startups and learn thee lingo like that.

Are you planning to keep in venture capitalist
capital for the extended term? The full ratchet assure
prevents dilution, considering that the proportionate ownership
would remain the very same as when the investment was initially produced.
Ответить | Ответить с цитатой | Цитировать | Сообщить модератору
capital venture
0 # capital venture 04.09.2021 22:54
"Venture capital venture" is
an business term that several entrepreneurs will latch onto without havig genuinely understanding the actual scope of what it signifies.
EXOR’s aim is to beat the MSCI World Index in Euros inn tthe lengthy term by
waay of the enhance in its Net Asset Value (NAV). As off Tuesday’s close,
its stake was worth just around $12 billion, generating
Didi an unprofitable trade if 1 accounts for the time value oof cash.
They’ll then not only add value in common butt will unlock the
worth of the equity, a distinct skill which majy owners
don’t however have, for the reason that they haven’t necessary to.
Taking a substantial step forward with a business typically requires some sort of
investment and in basic there are two recognised financial routes.
Many other monetary routes are closed off in the present climate and nnon economic
adjustments, whilst potentially constructive, will not hawve the exact same effect.
Cap table, monetary liability (loans or encumbrances), so that they could
understand the terms in which othher people invested and what outstanding liabilities the organization may possibly be subject to that could effect cash flow and revenue redemptions.

Total Investment is the total quantity off capital the VC fund has
invested. The bigger the fund, the bigger the conmon amount
off investment per company,with rights for stick to on investment.
Ответить | Ответить с цитатой | Цитировать | Сообщить модератору
capital venture
0 # capital venture 05.09.2021 05:56
Dr. Makower led a study thawt details how sufferers in Europe are acquiring access
to new therapies an typical of two years prior to individuals in the United Sates due to regulatory challenges at the FDA.
Have annual earnings off $200,000 per yeaar for the previous two years, with a sturdy likelihood
of similar earnings in the close to future.
We held discussions with the founders oof varied and notable
eschange houses and viewed as listing selections for D’Coin and the future
of blockchain technologies and the ramifications for our D’Crypt platform.

But, as yyou know, when your company satisfies a social or
enviironmental require, your possibilities ffor funding are even scarcer.
It’s quite challenging to break into venture capital directly
outt of undergrad, and even if you have the background for it
- i.e., you went to Stanford or Berkeley, majjored in CS, and completed multiple startup and finance internships - it is not necessarily a
great notion to do it. This is where significant-scale CVCs offer a valuable advantage ovewr traditional venture
capital firms. Since thhe achievement of the venture capital venture firms is dependent
on the results of your enterprise, they will operate with your organization and aid you make it rich.
Ответить | Ответить с цитатой | Цитировать | Сообщить модератору
Judi Online
0 # Judi Online 22.09.2021 08:39
This is a topic that is near to my heart... Thank you! Exactly where are your contact details though?


Also visit my web page - Judi Online
Ответить | Ответить с цитатой | Цитировать | Сообщить модератору