Jump to content


Best way for load 50,000 rows (best speed)

  • Please log in to reply
2 replies to this topic

#1 jamiguel77

  • Members
  • 137 posts

Posted 27 December 2019 - 08:55 AM



how to load 50 000 rows (with 30 columns) best way? best speed.


i have 2 options:


1) Text File:


#9#9#9'20191122'#9#9'1400067806'#9'KR'#9'22.11.2019'#9#9#9'-7,550.00'#9'MXN'#9'200031621'#9'CAJA DE AHORRO LCM2 SEM 46'#9'CAJA DE AHORRO'


2) i have this text file (Separated by columns) in a mysql database..





#2 jamiguel77

  • Members
  • 137 posts

Posted 27 December 2019 - 09:39 AM

Same time if addrow(50000) or one by one.


finally i need asign to every row / cell a value....



#3 Boki (Berg)

Boki (Berg)

    Boki (Berg)

  • Forum Admin
  • PipPipPipPipPip
  • 7,901 posts
  • Gender:Male

Posted 28 December 2019 - 10:06 PM



Maybe one of the suggestions can be using built-in method:



You can also open the source file and inspect how I done it there.

boki@bergsoft.net | LinkedIn Profile
BergSoft Home Page: www.bergsoft.net
Members Section: bms.bergsoft.net
Articles and Tutorials: dn.bergsoft.net (Developers Network)
BergSoft Facebook page
Send us applications made with our components and we will submit them on: www.bergsoft.net/apps.htm. Link to this page will be also set on home page too.

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users