From: luke <lduncalfe@...>
Date: 2005-07-07T18:00:47+09:00
Subject: how quick is .split()?


hi all

i'm about to enter 300-500 words into a mysql database, which a rails app
will retrieve. i'm wondering which method would be quicker for a server to
perform:

a) retrieving individual words from 300-500 rows in the database, one to a
row.

or

b) have only one row in the table and this is a concatenated string of all
the keywords, which is .split(), with ruby retrieving the values that way.

i was about to ask this to the mysql group, but then thought that it's more
a question about the speed of the ruby .split() method perhaps :)

thanks
luke