there are provinces, cities and autonomous regions in excel, and there are Chinese characters
such as
is directly imported into the database, the Chinese characters are saved, and the four-level linkage cannot be done, so I wrote the method: first get the excel Chinese characters, then look up the corresponding codes through the Chinese characters, and then save them in the database
. < H2 > at this time, the problem arises. As soon as the amount of data is large, the import is very slow. The provinces, cities and regions of each piece of data have to find the corresponding code, and 200 pieces of data have to be imported for more than 10 minutes. Is there any great guidance on which aspects should be optimized < / H2 >