SQLite Forum

select in order
Login
Computing speed is not a relevant consideration.  Just because you *CAN* insert a bazillion rows per second does not mean you *WILL* insert a bazillion rows per second.

There are other limits on the rate at which rows can be inserted that have nothing to do with computing speed.  For example, if you added a row for every person that was "born" it is not relevant how fast you can insert records (as long as it is fast enough), the limiting factor is the rate breeding rate of humans populating the planet.

Similarly the rate of insertion into the *customer* table is based on the growth rate of customers and not the speed of the computing device.  So while you may be able in a hundred years to be able to acquire customers at a rate that would allow you to exceed the limit, that fact is irrelevant, since it is not that limit that is meaningful.

The "speed" of the computing device has little, if anything, to do with it in any real sense.