automatic insert into Mysql with C API

Question

I want to simulate the updating process's for my mysql table I want to insert every one second a data into mysql table in autaumatic way

the idea is to write a small loop with C API that support sql request (or any other languages) and execute this loop to insert data to mysql I read many topics here or in others forum but I need help to find how to implement the constraint of time ( every one second ).

Chimera · Accepted Answer · 2012-07-16 04:00:05Z

2

Most languages have a sleep() function. In the loop sleep() for one second. PHP: Sleep() C: Sleep()

answered Jul 16, 2012 at 4:00

Chimera

6,0787 gold badges52 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ben Over a year ago

thanks jim very good news for me ! but for the case of php how I start insert my data, that means my php script should be independent of my system so how to trigger the execution of my loop ?!

wallyk · Accepted Answer · 2012-07-16 03:59:45Z

1

Sure, this is a standard load testing methodology:

 while (not done)
 {
      sleep (1);
      mysql.query("insert into table values (blah, blah, blah)");
 }

Probably you would want to run several instances of this program, and probably refine the use of sleep() to use greater precision based on how long the query took.

answered Jul 16, 2012 at 3:59

wallyk

58.1k17 gold badges92 silver badges155 bronze badges

1 Comment

Ben Over a year ago

yes that's right I have many data to add, but I want to trigger the program just one time Thanks for your helpful post

Collectives™ on Stack Overflow

automatic insert into Mysql with C API

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related