Optimizing Feedapi
When using feedapi and making nodes out of feedapi items, this can cause quite a load on the server.
If using sql search in particular, may cause the database to be bogged down, because each feed can generate a handful to 100's of feed item nodes.
There are quite good viable alternatives to sql core search, with the use of apache solr search module, xapian, sphinx amongst others.
However, using other search options, require extra technical / systems admin skills in handling external services, such as either the jetty engine or tomcat that the apache solr module uses.
An interim solution is to not index the feed item nodes. This involves the patch to node.module from http://drupal.org/node/341133, to wrap db_rewrite_sql around the query.
function mymodule_db_rewrite_sql($query, $primary_table, $primary_field, $args) {
// Using patch on d.org/node/341133 to not index feed items
if ($primary_table == 'n' && $primary_field = 'nid' && empty($args) &&
$query == 'SELECT GREATEST(IF(c.last_comment_timestamp IS NULL, 0, c.last_comment_timestamp),
n.changed) as last_change, n.nid FROM {node} n LEFT JOIN {node_comment_statistics} c ON n.nid = c.ni
d WHERE n.status = 1 AND ((GREATEST(n.changed, c.last_comment_timestamp) = %d AND n.nid > %d) OR (n.
changed > %d OR c.last_comment_timestamp > %d)) ORDER BY GREATEST(n.changed, c.last_comment_timestam
p) ASC, n.nid ASC') {
$where = " n.type NOT IN (,'feeditem') ";
return array('where' => $where);
}
}
Nicely done.
Submitted by Anonymous on Mon, 2011-12-12 03:59.Wish to discover how you can fly. The least expensive method to do that's having a flight simulation game online. Individuals have been wanting to discover how you can fly a plane for years, but only a couple of of them really do it. The primary issue with flight school is the fact that it expenses a great deal. So who would need to pay quite a bit to learn tips on how to fly when they almost certainly will not even afford to obtain a plane to fly with. But you are able to discover the fundamentals in flying, or practice what you currently learned having a great Flight Simulation Game Online.
Most flight simulation games aren't on-line. So you'll get bored with the exact same aircrafts and sceneries fairly quick. But this specific flight simulator is on-line. That will guarantee an incredible wide variety of planes to utilize and also of places to see.
green tea facts
Submitted by Anonymous on Mon, 2011-12-12 03:34.Hey, I just hopped over to your site via StumbleUpon. Not somthing I would normally read, but I liked your thoughts none the less. Thanks for making something worth reading.
green tea
primark
Submitted by Anonymous on Mon, 2011-12-12 02:01.Hi , im very glad that i came across this website! im going through a tough period, have to deal with some unpleasant issues and finding something positive here makes me feel better im going to read more many thanks again. For more
If using sql search in
Submitted by Anonymous on Mon, 2011-12-12 02:33.If using sql search in particular, may cause the database to be bogged down, because each feed can generate a handful to 100's of feed item nodes. Accident Claims
for sale
Submitted by Anonymous on Mon, 2011-12-12 01:37.http://ps3bundlenews.com/ps3-for-sale/Great video. It was really touching. I am very lucky that i was born with both parents. Remember to always love your parents. We are nothing without them.
for sale
Submitted by Anonymous on Mon, 2011-12-12 01:21.Great video. It was really touching. I am very lucky that i was born with both parents. Remember to always love your parents. We are nothing without them.http://ps3bundlenews.com/ps3-for-sale/
folklore
Submitted by Anonymous on Mon, 2011-12-12 00:31.Appreciate your making the effort to discuss this, I find myself strongly about this and lovmind updatie reading much more about this topic. Whenever possible, as you gain knowledge, do you mind updating your site with extra information? It's very helpful for me
vanquish
Submitted by Anonymous on Mon, 2011-12-12 00:10.This is amazing and wonderful site. These plants show slight movement when an external magnet is positioned close to them.
Her experimental art practice was developed in an interdisciplinary capacity with the center.
tekken
Submitted by Anonymous on Sun, 2011-12-11 23:49.That is very good comment you shared.Thank you so much that for you shared those things with us.Im wishing you to carry on with ur achivments.All the besthttp://ps3bundlenews.com/ps3-bundle-tekken-6-ps3/
bundle fifa 2011
Submitted by Anonymous on Sun, 2011-12-11 23:28.Perfect piece of writing rich in information. I have been looking for such a post for a long time. Thanks again.http://ps3bundlenews.com/crash-bandicoot-ps3/
bandicoot
Submitted by Anonymous on Sun, 2011-12-11 23:17.Thanks for sharing this. I really find this informative and well written
best ps3
Submitted by Anonymous on Sun, 2011-12-11 23:05.It is easy to see that you are impassioned about your writing. I want I had got your ability to write.http://ps3bundlenews.com/ps3-bundle-best-ps3-games-2011/
games
Submitted by Anonymous on Sun, 2011-12-11 22:48.I recently came across your article and have been reading along. I want to express my admiration of your writing skill and ability to make readers read from the beginning to the end. I would like to read newer posts and to share my thoughts with you.
Nice read
Submitted by Anonymous on Sun, 2011-12-11 22:34.Very interesting article. Content has been written in very nice manner. I enjoy reading this kind of stuff. Thanks for sharing good knowledge. free cell phone spy software
homefront
Submitted by Anonymous on Sun, 2011-12-11 22:32.I recently came across your article and have been reading along. I want to express my admiration of your writing skill and ability to make readers read from the beginning to the end. I would like to read newer posts and to share my thoughts with you.
singstar
Submitted by Anonymous on Sun, 2011-12-11 22:15.It's good if you still have your mom beside you. Don't ever think to cheat on her or making her mad and regretting to have you. That's insane man. Be good to your parents, you'll be honored by your child in the future.http://ps3bundlenews.com/ps3-bundle-singstar-ps3/
castlevania
Submitted by Anonymous on Sun, 2011-12-11 22:08.A real story of the life, we barely notice. Thanks to bring them on focushttp://ps3bundlenews.com/ps3-bundle-castlevania-ps3/
netflix
Submitted by Anonymous on Sun, 2011-12-11 21:30.These street children need more care . perhaps they could be some thing in life one day
bundle ps3
Submitted by Anonymous on Sun, 2011-12-11 21:16.You need to be polite if you talking to your mom. Moms could be like a friends to you, but they are still your parents. Be good to them and you'll never regret it.
combat
Submitted by Anonymous on Sun, 2011-12-11 21:02.Moms sometimes could be annoying if they don't understand what we need but keep trying to make us to be sure about her choice. It doesn't mean they don't understand what you want, but they trying to give the best of what they had. Just it. http://ps3bundlenews.com/ps3-bundle-ace-combat-ps3/
shift
Submitted by Anonymous on Sun, 2011-12-11 20:49.http://monsoonclothings.com/shift-dress/This is the best blog for anybody who needs to seek out out about this topic. You realize so much its virtually hard to argue with you. You definitely put a new spin on a topic that's been written about for years.
clothing online
Submitted by Anonymous on Sun, 2011-12-11 20:33.normally the top choice for investment are stocks / FD / properties. With interest rates @ record low, bank rates for FD can't even beat inflation.. Stocks now seems a good buy though, its like 20% discount from 2 months ago? Think its worth shopping for good buy..http://monsoonclothings.com/clothing-online/
coast
Submitted by Anonymous on Sun, 2011-12-11 20:24.Cartoons and quotes of admiral are rarely made. However, admiral is not a common topic people`ll talk about. Besides, public`s knowledge about the navy is less.http://monsoonclothings.com/coast-dresses/
dresses
Submitted by Anonymous on Sun, 2011-12-11 20:23.Don't turn your back on your favourite latte yet, that one espresso provides a number of health benefits. Buy Coffee Online. If you like coffee and you are able to tolerate it well, enjoy it...guilt free. All you coffee drinkers who are looking for a legitimate excuse to reduce your coffee intake for health reasons, hold that thought for a second and thank UCLA researchers who have given all of us another reason why we shouldnt stop our coffee intake just yet.http://monsoonclothings.com/new-york-dresses/
monsoon sale
Submitted by Anonymous on Sun, 2011-12-11 20:03.You will also have the option to buy in-game currency, which is called Crowns in this game. Your actions will also be dependent on Energy and Castle points. http://monsoonclothings.com/monsoon-sale/
casuals
Submitted by Anonymous on Sun, 2011-12-11 19:56.First of all you have quests to do. You do all sorts of tasks for characters in the game to gain coin and experience. So it makes the game be a lot more enticing than other Zynga games. The same concepts have been kept though. You will have to add friends to your game in order to advance.http://monsoonclothings.com/country-casuals/
shops
Submitted by Anonymous on Sun, 2011-12-11 19:51.If people try out a Greater toronto area House Variety you'll recognize that a suitable necessary give a call to be that inturn metropolis that will help you live. Exceeding 20.Tips and hints 1001 most folks all across Greater toronto area a simple keep on functional and additionally age, imaginable in what way huge one city domain Greater toronto area is.
monsoon dresses
Submitted by Anonymous on Sun, 2011-12-11 19:41.I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well.http://monsoonclothings.com/monsoon-dresses-berketex//
petite
Submitted by Anonymous on Sun, 2011-12-11 19:41.Im impressed, I must say. Very rarely do I come across a site thats both informative and entertaining, and let me tell you, youve hit the nail on the head. Your site is important; the issue is something that not enough people are talking intelligently about. Im really happy that I stumbled across this in my search for something relating to this issue.http://monsoonclothings.com/monsoon-dresses-petite-dresses/
debs
Submitted by Anonymous on Sun, 2011-12-11 19:29.Thinking to get a solar power system for home but don't know where to start and what to do? There are systems to buy which are ready to go, all you need to do is install them. But those can be very expensive. money market. There is an alternative though, you can build your own system for very little money and still keep it's efficiency levels up. http://monsoonclothings.com/monsoon-dresses-debs-dresses/
perkins
Submitted by Anonymous on Sun, 2011-12-11 19:24.Thanx for a very interesting web site. Where else could I get that kind of info written in such an ideal approach? I have a undertaking that I'm just now working on, and I've been at the look out for such information.http://monsoonclothings.com/monsoon-dresses-dorathy-perkins/
websites
Submitted by Anonymous on Sun, 2011-12-11 19:10.Took me time to read all the comments, but I really enjoyed the article. It proved to be Very helpful to me and I am sure to all the commenters here! It's always nice when you can not only be informed, but also entertained! I'm sure you had fun writing this article.http://monsoonclothings.com/monsoon-dresses-clothes-websites
new york
Submitted by Anonymous on Sun, 2011-12-11 18:46.Can I just say what a reduction to search out somebody who really knows what theyre talking about on the internet. You undoubtedly know the best way to deliver an issue to light and make it important. More individuals must learn this and perceive this side of the story. I cant imagine youre not more fashionable since you positively have the gifthttp://monsoonclothings.com/new-york-dresses
I really don’t think anyone
Submitted by Anonymous on Sat, 2011-12-10 06:33.I really don’t think anyone has put it that way before!. Your blog is definitely worth a read if anyone finds it. I’m lucky I did because now I’ve got a whole new view of this. epson workforce 840
online roulette for money
Submitted by Anonymous on Fri, 2011-12-09 22:36.Roulette is world Famous CASINO GAME, online roulette for money, play roulette, we offer top three Casinos Games,
roulette tips, online roulette.
online roulette for money
Beauty Salons
Submitted by Anonymous on Fri, 2011-12-09 02:45.Beauty Salons
Really nice blog this is and a great way to know the things which is necessary to know,great job you did.
Beauty Salons
Great stuff.
Submitted by Anonymous on Fri, 2011-12-09 02:13.In these hard financial times, you want to save money where ever possible. Well you can do that with Satellite Direct TV. If you think that you are paying too much for your TV channels, and want to get rid of that extra cost, Satellite Direct TV is what you need. To be honest, we all pay TV companies a lot of money every month to be able to watch our favorite programs. Well you can forget about all that because there is the Internet. Satellite Direct TV.
In the past, all we had was the television set. That is why the media providers could do anything they wanted. They do that now too, but we don't have to take it anymore. Satellite Direct TV is the best TV to PC program available now. You will receive the channels on your computer or laptop and can view them there. Also, you can connect your device to any TV and watch any program you want on a big screen. So here is why you will love Satellite Direct TV over any cable service.
Thiss..
Submitted by Anonymous on Fri, 2011-12-09 01:09.This is such a beautiful topic that me and my friends are talking about.
Software Akuntansi
Baju Wanita
Submitted by Anonymous on Fri, 2011-12-09 01:03.I am quite excited with all the article content of your site. It would be my pleasure to gather some more strategies from your web-site and come up to offer people what I have benefited from you.
Baju Wanita Import Korea
womens
Submitted by Anonymous on Thu, 2011-12-08 23:56.Do you think that substandard nursing is caused by bad training, or not enough support when the new nurse starts working?
international
Submitted by Anonymous on Thu, 2011-12-08 23:45.Housing cost could be very high. The location will establish it. Then, the vast of the world additionally often is the aspect that establish the value of a house.
matalan
Submitted by Anonymous on Thu, 2011-12-08 23:31.Your page is so exciting there are lots of learnings to read on this page thanks a lothttp://primarkclothes.net/primark-clothes-matalan-sale/
primark jobs
Submitted by Anonymous on Thu, 2011-12-08 23:11.Wow, what a blog! I mean, you just have so much guts to go ahead and tell it like it is. I am bound the previous eras are tougher and slightly barbar. http://primarkclothes.net/primark-clothes-primark-jobs/
clothes
Submitted by Anonymous on Thu, 2011-12-08 22:47.hy guys i love passion a respact that gay i really reallyyyyyyyyyyy like nice worrkkkkkkkkkk.http://primarkclothes.net/primark-clothes/
Beauty Salons
Submitted by Anonymous on Thu, 2011-12-08 19:42.Really nice blog this is and a great way to know the things which is necessary to know,great job you did.
Beauty Salons
magnificent post !
Submitted by Anonymous on Thu, 2011-12-08 00:26.Wow! This could be one of the most beneficial blogs we've ever come across on thesubject. Actually magnificent post! I am also an expert in this topic so I can understand your hard work.
toko online jual sepatu murah|grosir sepatu sandal kulit online
Code Ramblings
Submitted by Anonymous on Wed, 2011-12-07 10:37.I am trying to find something like that, thank you for sharing, I will mark it as a bookmark. music production
Nice information about
Submitted by Anonymous on Wed, 2011-12-07 01:57.Nice information about Feedapi & making nodes for it.Thank you for sharing this.It will help the people like this.
Mobile Apps Development
very clothing
Submitted by Anonymous on Tue, 2011-12-06 23:30.I'm not positive whether this post is written by him as nobody else know such detailed about my trouble.http://jigsawclothings.com/jigsaw-clothing-very-clothing/
mortgage plan
Submitted by Anonymous on Tue, 2011-12-06 19:09.Good site that has all the information on the dynamic content. This is really a very informative one that can be checked through this site.
mortgage plan