100,000 rows memory question

[webnick]

Hi, I'm working with an organization that would like to make mainframe data available to clients via the web. We're using a java solution but changes in data or a large extract and MYSQL seemed more manageable.

The simplest solution gives me a 30 column text file with, literally, 100,000 lines. What are the perfomance consideration for importing something like this into one table? It could be broken out like a-g, h-l, m-p, q-z but will still hit the database with a query for each row, every night.

Actual surfer calls should be under 12 visitors at a time. Thanks for any thoughts,
NM

[MarkR]

100k rows isn't really that big. Imports should take at most a few seconds (depending on lots of factors).

Of course you might want to lock the table and/or somehow prevent web hits during the import.

Seriously though, 100k rows is nothing to write home about 🙂

Mark