If I interpret correctly, you'd like to to read sensor data (not in ASCII format) as FLOATs and insert it into a database on the fly without an intermediary. While this may be possible, perhaps there's a better solution.
I would suggest reading the data to a file (which you must be able to do any way) for the duration of your test. When the test is complete, parse the data and do a batch insert into the database. MySQL will report the number of rows recorded, which can act as your polling system. If you are able to provide more details about your application, perhaps we can be of more help. Most significant is likely the data format coming from your sensors. Edward Dudlik Becoming Digital www.becomingdigital.com ----- Original Message ----- From: "Chris Webster" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, 12 June, 2003 11:46 Subject: soft real-time database Greetings, I'm new to databases, but I am considering one for soft real-time data recording of scientific data. Then any client/display program can grab data. I'll be recording 300-500 variables/columns per second for about 10 hours at a stretch. All variables are floats. a) Is there a way to insert/write floats to the DB without converting to ASCII first? Seems expensive. b) I'm still wading through the documentation, but what would be the prefered method for polling to see if a new row has been written? I assume there is no notification process available from the server.... TIA for any pointers. -- --Chris I don't approve of political jokes. I've seen too many of them get elected. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
