in reply to Perl or Mysql to store multiple choices?

I would definitely go with the DB oriented soln:
Create 1 table with cols for update_id, option, qn_num and index as needed. The main performance issue is going to the DB, but a single table select with indexes is v fast and as noted, 250k rows isn't that many.
The while loop to retrieve will not take a noticeable amt of time.

Cheers
Chris

  • Comment on Re: Perl or Mysql to store multiple choices?