Recent Posts

Handbags ladies!

Play nice

Your move, Curtains.


Ooh, it's just like the glory days on .Net.




 

Hi all.

I'm having some problems with slow searching of a view that unions two tables in mysql...

table one, is large with lookup contents for some 1.2m records
table two, same stucture but with local custom records - circa couple of hundred.

each get updated fairly regularly, they are unioned together to form one view to search from.

The user searches a view to return a record, but it is painfully slow. searching either table directly returns result relatively quickly, but searching the view can be minutes.

whats the best way to overcome this...? can I index views? I can't seem to find anything  relatively recent?

if not, is there some nifty php to use one query to search both tables one after the other.... will have a  unique identifier across both tables.

Thanks in advance.

Scoob

A modern Orthodox Jewish couple, preparing for a religious wedding meets with their rabbi for counselling. The rabbi asks if they have any last questions before they leave.

The man asks, "Rabbi, we realize it's tradition for men to dance with men, and women to dance with women at the reception. But, we'd like your permission to dance together, like the rest of the world."

"Absolutely not," says the rabbi. "It's immodest. Men and women always dance separately."

"So after the ceremony I can't even dance with my own wife?"

"No," answered the rabbi. "It's forbidden."

"Well, okay," says the man, "What about sex? Can we finally have sex?"

"Of course!" replies the rabbi. "Sex is a mitzvah a good thing within marriage, to have children!"

"What about different positions?" asks the man

"No problem," says the rabbi "It's a mitzvah!"

"Woman on top?" the man asks.

"Sure," says the rabbi. "Go for it! It's a mitzvah!"

"Doggy style?"

"Sure! Another mitzvah!"

"On the kitchen table?"

"Yes, yes! A mitzvah!"

"Can we do it on rubber sheets with a bottle of hot oil, a couple of vibrators, a leather harness, a bucket of honey and a porno video?"

"You may indeed. It's all a mitzvah!"

"Can we do it standing up?"

"Absolutely Not!" says the rabbi."

"Why not?" asks the man.

"Could lead to dancing!"

With respect, I am not a client who knows bugger all, in fact I'm nobody's client. I do have a little expirience in building and running an ecommerce site, All I needed was a few tools to help check things like keyword density etc.

Fine, Mr Know it all, I'll butt out.

Thanks, I'd appreciate that.

The SEO book tools are good - particularly the Firefox extension for easy rank monitoring. And I also swear by the SEOMoz ranking factors list.

But like net-curtains says, the best thing to do is to have plenty of fresh content that other people want, and do, link to.

Winner!

Thanks

ah ok. There's quite a few flv players that you can download and use on your site. I looked at this one - http://flvplayer.com/ before our client went off and used screencast

With respect, I am not a client who knows bugger all, in fact I'm nobody's client. I do have a little expirience in building and running an ecommerce site, All I needed was a few tools to help check things like keyword density etc.

Fine, Mr Know it all, I'll butt out.

Well, I already know that my code should be clean and semantic (I'm not sure how net-curtains knew the site in question wasn't clean and semantic without the URL but there you go) so that considered and the fact that wasn't actually what I asked I'll make him feel right at home here and I'll ignore him too

Sorry if I sounded grumpy, I'm just used to clients asking for a quick fix SEO 'tool' that will magically make their site appear at 'the top of Google', yet never bother to update their website with content, or write more than a paragraph in the first place.

I'm sure your code is lovely, but if your site is slipping then it's probably because you're not keeping it updated, otherwise it wouldn't be slipping.

Personal experience has shown me that keyword twiddling and even link building is not as effective as keeping your site up to date with good quality content and by marketing your website on and offline.

With respect, I am not a client who knows bugger all, in fact I'm nobody's client. I do have a little expirience in building and running an ecommerce site, All I needed was a few tools to help check things like keyword density etc.