-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 Neil, The short answer is probably "merge the two databases manually and rebuild the index". I don't think there's any real answer otherwise. Given the old version of MySQL you aren't going to be able to do anything fancy like federating the two tables to into another database and making a view out of the two or anything. Actually the only other possible alternative is to do a myisam_ftdump - -s on both databases and get the Average Global Weight for each database and then use one to "normalize" the results from the other, reading...
http://www.databasejournal.com/features/mysql/article.php/3512461 ...states the the query weight (final score) also depends on the local weight but that's okay (I think). So, er, right... To get the approximate query score for database 1 from a score retrieved in database 2 multiply it by the Average Global Weight of db1 divided by the Average Global Weight of db2. I think, it's a bit late ;^). Hence... The approximate database one Query Score = database two's Query Score * (database one's Average Global Weight / database two's Average Global Weight) A) It is only an approximation, IT IS NOT accurate. Your mileage will vary depending on the similarity of the contents of the two databases. B) Get a second opinion on that. Try it and let us know how well it works. Regards, Phil > I've been using the MATCH() with FullText Scoring for quite a while now > on one table. I now need to combine the data from another database. I > have : > > Database1.Table1 > > with > > Database2.Table1 > > If I use the the FullText scoring using just one database/table it is > OK, but when I query the database1 and then database2 the scoring is > totally different because the data is different in each database. > > What would be the best way to overcome this problem. We are using a > early version of mysql 3.28 and can't upgrade at this time. > > Thanks for any help. > > Neil > > _________________________________________________________________ > Exclusive Ed Byrne daily comedy clips on MSN Video > http://specials.uk.msn.com/edbyrne/ > > -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org iD8DBQFF3jl4umMVa2pwPmkRCk62AJ9E30ogX1BqeKGiYqxcyWCpgjxH4QCfepxj qlTWplUZ3HsU3JsA4pm80Ls= =19pZ -----END PGP SIGNATURE----- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
