ThinkDing

ThinkDing (http://www.thinkding.com/forum/index.php)
-   Pre-Sale Questions (http://www.thinkding.com/forum/forumdisplay.php?f=3)
-   -   does the tdsearch modify the sql database? (http://www.thinkding.com/forum/showthread.php?t=39)

montero 09-26-2007 03:25 AM

does the tdsearch modify the sql database?
 
Hi I'm thinking of buying this script but I'm wondering whether it will work for me. I want to search a textpattern blog database that I'm setting up, but I'm wondering whether by using tdsearch will corrupt the textpattern blog database? I read on your announcements that the tdstatistics logs are added as a column in a the search database? Do I understand that correctly? ... so it actually modifies the database that it searches?

Thanks.

Winston 10-14-2007 05:41 PM

Sorry for the delayed response, but to answer the questions, tdSearch adds a FULLTEXT key to the table to be searched, and tdSearchStats uses its own table. Neither of these would corrupt data, but of course you should backup beforehand. The table to be searched should have the following form:
Code:
CREATE TABLE search_data ( title varchar(255) NOT NULL, description text NOT NULL, keywords text NOT NULL, url varchar(255) NOT NULL, size varchar(255) NOT NULL, date varchar(255) NOT NULL ) TYPE=MyISAM;


All times are GMT. The time now is 08:23 AM.

Powered by: vBulletin Version 3.0.7
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.