I need to import a hefty amount of BoMs into tiny (about 130K) , it works if i split the file into multiple CSV but crashed while trying to load it all (it did import all 68K of my products at once nicely wich went against my 65K limit thesis) , is there a hard limit somewhere?
Also i'm getting pretty abysmall import performance on BoMs and i'm wondering what's causing it , importing 68K products took 6minuts or so (wich is long imoh but in human time it's pretty insignificant) however importing BoMs 20K by 20K is taking about 1 hour and a half per batch... I find this weird since importing a 1hour and a half >5000 seconds... It can't really be importing only 4 per seconds on a core 2 duo with 4 gigs of ram? I'm pretty clueless about sql & DBs overall but i was thinking maybe it's trying to spit the whole batch in a single transaction & that lower performances? Any clues are welcome since i will prolly rewrite my product/BoM generator a few time and will need to import to test (for comparison on this computer it takes < 2 seconds to parse files for elements and generate all possible products , codes and their BoMs and spit them to CSV files when i put in enought combinations to reach 2million products/4M BoM) _______________________________________________ Tinyerp-users mailing list http://tiny.be/mailman/listinfo/tinyerp-users
