Re: [PHP-DB] Text Searches on MySQL

2001-03-15 Thread Jon Valvatne
First of all, to answer the inital question, here's a quote from the database: * It's not normally useful to split a table into different tables just because the rows gets 'big'. To access a row, the biggest performance hit is the disk seek to find the first byte of the row. After finding the da

Re: [PHP-DB] Text Searches on MySQL

2001-03-14 Thread Ron Brogden
At 05:05 PM 3/14/2001 +, you wrote: >I'm putting together a db with articles in it. Would it be better to have two >tables with the main text of the articles in it linked to a main article >table or just chuck it all in together in one table. >I want to be able to do a full text search on the

[PHP-DB] Text Searches on MySQL

2001-03-14 Thread Jordan Elver
Hi, I'm putting together a db with articles in it. Would it be better to have two tables with the main text of the articles in it linked to a main article table or just chuck it all in together in one table. I want to be able to do a full text search on the articles. Any help please, Cheers,