On 11/1/07, carter ck <carterck32@xxxxxxxxxxx> wrote:
>
> Hi all,
>
> Has anyone come across a solution for faster and powerful search stored procedure in a table that contains more than 500K of records?
>
> I am currently trying to work around with it. All helps are appreciated.
Are you using the tsearch2 full text engine? If not, you're missing
the boat for fast searching text. But you didn't really tell us what
exactly you're searching on, so I'm just guessing.
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
