Jump to content


Photo

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


  • Please log in to reply
2 replies to this topic

#1 jamiguel77

jamiguel77
  • Members
  • 137 posts
  • Gender:Male

Posted 27 December 2019 - 08:55 AM

hi 

 

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..

 

 

Thanks

 



#2 jamiguel77

jamiguel77
  • Members
  • 137 posts
  • Gender:Male

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
  • 8,191 posts
  • Gender:Male

Posted 28 December 2019 - 10:06 PM

Hi,

 

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

 

NextGrid61.Serialize.LoadFromCSV();

 
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
Users Section: users.bergsoft.net
Articles and Tutorials: help.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