I'm about to create a search engine for my company that
will use MS SQL Full Text 7. If someone can help in
this task, I'll be glad:
I have all the necessary content (text only files) stored
locally on a developing server (which is also used as my
spider for content). Currently I'm performing this:
1. check filedate, if greater then the filedate colum
that is stored in the DB, overwrite this row to contain the new file information and
mark fileupdate colum=1
2. when all files are checked, a c++ program (which is
handeling hunderds of thousdands of files) is updating
the LOCAL SQL server, used for developing uses it
built in ODBC connector (i.e - not using DTS from SQL
to import the data).
3. when the database is updated with the files and files
information and on OFFHOURS, A Replication Job start at the
LOCAL DEVELOPING sql server, using PUSH - to the PRODUCTION
SERVER in Europe.
4. after which, the production server updates the full text catalog, using incremental
update.
If I'm doing something wrong or inefficient, please
let me know.
Thanks,
Michael.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
