How to limit search result

[clems365]

Hi all

My pligg site has more than 40.000 article (and 2.000 users per days), so in a search I can have more than 300 resultat ... This funcion take a lot of resource in my hosting, so I would like to limite the result (to the 50 newest result), I saw in html1.php in related story this line

$sql.= " GROUP BY ".table_tags.".tag_link_id, ".table_links.".link_title, ".table_links.".link_title_url ORDER BY link_published_date DESC [b]LIMIT 10[/b]

I think it's possible to make the same in libs>search.php, but I don't no where.

If somebody can help me, many thanks

Clément

[blaze]

Try this post.

[clems365]

Originally Posted by blaze

Try this post.

ty

I find a solution, not the best, because I use "time"
in search under:

	if ($this->url != '') {
			if($this->filterToStatus != ''){$from_where .= ' AND ';}
			$from_where .= " link_url='$this->url' ";
		}

I put:

	if ($this->filterToStatus == 'all') {
			$tsdt = date('Ym01000000', strtotime("now"));
			$fsdt = date('Ym'.date('t', strtotime("now")).'235959', strtotime("now"));
			$from_where .= " AND (link_published_date >= $tsdt AND link_published_date <= $fsdt) "; 
		}

So I have the result in a month, but it's not my idea, I prefer 100 result in all time, it will be better for me.

But I will try to see if it's better in my server.

If somebody has a better idea, many thanks

clement

[ablaye]

I found a better way to do this.
In the html1.php page, you can limit how many pages of results are generated.
For example, I wanted to always limit the number of pages to generate on my index page for only 150 items at the most.

So in do_pages function, I added the following code after the global declaration:

	if ($thepage == 'published') {
	  $total = ($total > 150) ? 150 : $total;
	}

That ensured that I would only generate pages for 150 items at the most.
You can change that number by replacing the '150' in the code with any number.

Hope this helps.