Solr PHP help.

[xmonkeys]

Hey Guys I am trying to integrate solr into my tgpx system, which runs on php, but I am having some issues with it.
does anyone have any experience in this? Or could anyone help or offer their services?

Thanks.

[Presnus]

contact me on ICQ

[Babaganoosh]

I have some experience with solr and quite a bit with Sphinx. I have to ask, why do you need it if you're just using tgpx? Is the DB really huge or something?

[xmonkeys]

ya the db has close to 300k thumbs...and growing...am i setting it up wrong? is 300k not that big? :-) i m new and learning!

[Babaganoosh]

I can't see any reason to use something like that for a db of that size. I have one with 1.4 million records and a simple PHP script, a fulltext index and a well-configured my.cnf file make it nice and fast.

I'm running a custom script but it still stores data in mysql.

I guess I should ask how many searches you're anticipating per day before I try to talk you out of a search daemon.

[xmonkeys]

well i am just starting, so I dont know how many searches I am anticipating...
so ur saying my db isnt that huge and my search should be done rather quickly and without real delay, and without solr?
So here is my question, the search results take approx 4 to 5secs to load, you think it could be due to configuration?
you wanna maybe take a look and see y it would be loading slow? or maybe in ur eyes it is loading fast. check out the search at porntubehunters dot com lemme know if the search is rather fast or slow. I find that it takes a bit of a while to load.
Thanks again babaganoosh :-)

[Babaganoosh]

Yeah, that looks a little on the slow side. Are you on a shared server?

[xmonkeys]

Babaganoosh, I am on a shared server.
But, was in the process of moving it to a vps, in order to install solr, but that is where I got stuck the solr was giving me problems.

Do you think that transferring to a vps will make that much of a difference?

[xmonkeys]

hey Babaganoosh, someone suggested I try sphinxsearch.com, have you ever heard of it? what do u think of it?

[Babaganoosh]

In my first post I mentioned Sphinx. It works well if you have the hardware to throw at it. Your queries shouldn't be that slow even on a shared server. The host's mysql server is probably overloaded. See how it performs on a decent VPS. You'll almost definitely need to tweak your my.cnf but a db of that size shouldn't be beating you up too badly.

I don't know how tgpx works either. I don't know its db structure or anything so it might be a script issue too. For the kind of searching you're trying to do a fulltext index should exist on whatever column holds the descriptions and then use a fulltext query. If your search script is doing something like "SELECT * FROM tablename WHERE description LIKE %SEARCHTERM%" then that's a massive problem.

[xmonkeys]

Hey Babaganoosh, ya i just scrolled up and re-read ur first post you did mention sphinx.
Im gonna try and play with some settings today and tomorrow. i'll keep you posted on my progress. Waiting for the transfer to go through from my shared server to the vps.

thanks again for all your help and patience. Much appreciated.

[xmonkeys]

By the way Babaganoosh, we are doing a ""SELECT * FROM tablename WHERE description LIKE %SEARCHTERM%"" what do u suggest I do to change it? what other solutions r there? :-S

[Babaganoosh]

You're definitely going to want to do a fulltext query instead of a LIKE. Like queries are painfully slow for things like this.

Check this page for info on fulltext searching.
http://dev.mysql.com/doc/refman/5.1/...xt-search.html

[xmonkeys]

Thanks again babaganoosh. Reading it as we speak.
will keep u posted on progress! ur an amazing help. you have any site u want me to hard link to once my site is complete? will gladly hardlink it.

[xmonkeys]

Babaganoosh, thanks for all the help, it worked out perfectly with the fulltext query. The link u sent was amazing. Thank you so much for the help.
And again, if there is anyway I can help in return let me know, would gladly help.

thanks again.

[Babaganoosh]

That search is still really slow. I've tried it a few times to see if it improved. If you've got it implemented already then something is definitely wrong. You may need to tweak your my.cnf or even the PHP code for the search. Leave some contact info (email or ICQ) and I will see what I can do to help you out.

[xmonkeys]

hey babaganoosh, wasnt on for a bit. Ya you are right the search did get slow again, it was working fine for 2 days, then for some reason became extremely slow again.
you can reach me at icq: 601142993 or email [email protected]
Thanks again for all your patience and help.

[xmonkeys]

lemme know when ur on.
like check the site now, it seems much faster. it does it everytime, i dunno y.
some days it s fast, some days it s not!