insert mac addresses into a table of sqlite db
I’m trying to insert all Mac addresses into a table of SQLite that has a column Id not null primary key auto increment and a column MacAddress text not null. I want to insert all mac addresses that starts with 00:1A:79 and just uppercase letters. So in total that would be 16 777 216 macadresses. If I do it in c# it takes to much time. And if I do it directly in db browser for SQLite it works to paste all Macaddresses in and it works to execute. With no errors. But after the execution and when I’m trying to write changes the program (db browser for SQLite ) is not responding.
so how should I do this. Should I insert 1000000 MAC addresses each time in db browser or should I do something else?
3 Replies
inserting 16 million rows is going to take time, not much you can do about that
parameterizing the query or using bulk insert if sqlite supports that might help
You could probably write a sql query to generate all the address in a temp table and insert them at the end. Can even do it in batches
Unknown User•6mo ago
Message Not Public
Sign In & Join Server To View