TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Dave
NA
161
0
Performance Question
Dec 26 2007 8:17 PM
Hi all,
I have a question as to whether a database will be able to 'handle' a piece of code (it is a MySQL database i.e. client-server model). The pseudocode:
foreach client
update database with client details;
So, as it iterates through the clients, a simple UPDATE command is executed for each client. My question is, will there be any performance issue with this? Does the database need any kind of break in time between each UPDATE command, or can it handle being bombarded with the UPDATE statements at the high speed of the foreach loop?
My guess is that it can handle it, but I need to be sure and I don't have enough sample data to really test it. I am hoping this is an obvious question which someone can easily confirm, based on their experience.
Thanks
Reply
Answers (
1
)
gridview
Navigate Record