search

catfan / Medoo

The lightweight PHP database framework to accelerate the development.
https://medoo.in
MIT License
4.84k stars 1.15k forks source link

multi insert #640

Closed roydekleijn closed 7 years ago

roydekleijn commented 7 years ago

Hi,

How much faster is multi insert? are there some statistics on it ?

Which of the following is more efficient? 1 at a time, 10 at a time, 100 at a time

something else?

Thanks, R

Andrews54757 commented 7 years ago

@roydekleijn If you want efficiency, dont use Medoo. Medoo is an abstraction layer for those who dont know much about sql. I do not think you would need high-performing tools. If so, then use those provided by frameworks such as Laravel.

catfan commented 7 years ago

We optimized multiple insertion with one query as possible. For most of time, the speed for any database operations are based on the database engine or the machine itself, not the framework.