|
This may just sound
stupid but I am going to ask anyway.
We run a search
engine and we bring in 3+ XML feeds from other search engines Via perl and
PHP.
So we can end up with
300 results listed for EACH SEARCH. They are only valid for that ONE
SEARCH but we need to track every click for proper payment.
As you may imagine
this has a huge overhead to our mysql. We are growing and about to rewrite
our search engine and would like ideas on how to make the best use of these
temporary storage tables. Some of the tracking urls can be 440+ characters
long so we can't use varchar.
Also If you have 20
searches per minute coming in and 30 seconds between the clicks the table can
get quick big quickly. So jumping directly to right stored link
immediately if not quicker is a must.
Just spitballing for
the plan ahead. Wanting to make sure we use all the available speed
assests at our disposal.
Thanks |
