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?
so how should I do this. Should I insert 1000000 MAC addresses each time in db browser or should I do something else?
