I'm curious on what the benefits are of using sphinx search, and how it pertains to database quiries.
The reason I am asking as I just upgraded a site to 5.3.3 from 5.1.6. I had to remove several styles from upload just to avoid server time outs. But the biggest problem I ran into was after the upgrade, when I ran the "Rebuild Search Index." That process took me almost 12 hours as it caused server disconnects and I had to wait ontilthe site came back on line, only to run the next segment until the site got disconnected again. Each segment lasted about 8 minutes before the db closed the door on me.
The host has the site throttled to 300,000 queries an hour. Thats my problem.
So looking to see if Sphinx would be a benefit.
The reason I am asking as I just upgraded a site to 5.3.3 from 5.1.6. I had to remove several styles from upload just to avoid server time outs. But the biggest problem I ran into was after the upgrade, when I ran the "Rebuild Search Index." That process took me almost 12 hours as it caused server disconnects and I had to wait ontilthe site came back on line, only to run the next segment until the site got disconnected again. Each segment lasted about 8 minutes before the db closed the door on me.
The host has the site throttled to 300,000 queries an hour. Thats my problem.
So looking to see if Sphinx would be a benefit.
Comment