No, I think you will be fine. The RDMBS is designed to handle just that kind of thing. I do it for several applications at work, Helpdesk, etc. My hardest hit application inserts about 4K records a day, and I have not had any problems, and it has been productional for over two years.
If you are looking for a transaction system with row level locks ect that one would use for a larger and more complex system, lets say for online purchases etc you might want to check into the version of MySQL that they charge a little for. But my understanding is that would be for major systems. I would give it a run on the regular MySQL first, as I can't imagine that you would have any problems at all. MySQL is great, I am doing some testing on our systems (Data Warehouse) to see if it would be worthwhile to pull some of our OS/390 DB2 Data into MySQL tables. My testing so far shows that with one user one each MySQL is about 4 times faster! More testing is needed but it is looking good. Thanks, John Herbold IS Specialist/DBA -----Original Message----- From: Admin-Stress [mailto:meerkapot@;yahoo.com] Sent: Saturday, November 02, 2002 1:36 AM To: [EMAIL PROTECTED] Subject: mysql Sorry, another out of topic. Is it safe to use mySQL in cgi? I meant, if my update.pl perl cgi will do this : connect to mysql database insert into table values (values from FORM) ... other tasks ... close What happen if there are, let say 100 people accessing that perl cgi? I meant maybe there will be more than one connecting into database, is this ok? Will the mysql database be corrupted? In old days, usually we have to LOCK database in multiuser environment : connect to mysql database lock database // so other user should WAIT before they can connect ...update/delete/insert/etc... unlock close Thanks if you can enlighten me with current concept of mysql. Regards, kapot __________________________________________________ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.com/ -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
