any DBAs in the house?
 

A friend and I were scoping how to do a project, we ended up with a situation where we would have around 10,000,40,000 records that would have 5 variables each having to be updated every 5-10 minutes . How can you handle that kind of situation without not needing a quad-opteron? temporary tables?

Database
 

Jag,

#1. What kind of database do you plan on using?
#2. What kind of API do you plan on using to connect to the database?
#3. I've done this before. If you bulk load the data into a permanent table and then use a UPDATE x SET y = (SELECT z from aa where aa.bb = x.cc) in Oracle, or UPDATE x SET y = aa.z FROM aa WHERE x.cc = aa.bb in SQL Server
you would be able to pull this off with a single processor very quickly.

With SQL Server, it would not be hard to do. Same with Oracle or Postgres. You're not doing this kind of work with mySQL (good for inserts and deletes, but not updates from what I know, this is an involved subselect query).

PM me if you need more info :).

Mitch

Are you missing a digit or a dash here? :)

pm shall be done.