sqlite: Sistema de particion de carga de datos

[carsonzillo]

Buenas a todos

Os dejo otro ejemplo usando sqlite para usarlo en un sistema de partición de carga de datos que hice hace tiempo, le he puesto comments para mejor entendimiento. Lo creé para resolver un problema de carga de datos que superaban los 5000 mil items en listbox (al llegar a los 1000 se volvía lento a veces y jodía la aplicación cerrándola abruptamente). Tiene dos modos: 1- Carga cumulativa de datos mediante una cantidad fija de items a cargar (tanto en modo tramo, como en modo pagina) y 2- precarga de un tramo seleccionado de forma individual. Se parece al ejemplo que hice aquí pero este nuevo ejemplo es mas complejo de entender: https://amsspecialist.com/viewtopic.php?f=12&t=3103

Dejo un video demostrativo del ejemplo:


El apz con el ejemplo y su bbdd:

[usamakey]

tnks dude
great work

[abood1987]

Is there a password for download?

[carsonzillo]

Is there a password for download?

Edited, link download fixed, thanks abood for letting me the issue

[abood1987]

It came to my attention that you use repetition for the same purpose more than once in the same function and this is something wrong that consumes a lot from the processor .

This is a fraction of what I mean :

		-- tramos iniciales...
		for x=1, (totalTramosResult) do
			Table.Insert(tblInit, x, String.ToNumber(nbInicio));
			nbInicio = nbInicio+TamanoTramos;
		end
		concatInit = Table.Concat(tblInit, "\r\n", 1, TABLE_ALL);
		--Dialog.TimedMessage("Inits", concatInit, 5000, MB_ICONINFORMATION);	


		-- tramos finales...
		for d=1, (totalTramosResult) do
			nbFin = nbFin+TamanoTramos;
			Table.Insert(tblEnd, d, String.ToNumber(nbFin));
		end
		concatEnd = Table.Concat(tblEnd, "\r\n", 1, TABLE_ALL);
		--Dialog.TimedMessage("Endings", concatEnd, 5000, MB_ICONINFORMATION);	

This quick look at only and is not a complete review of your code.

[carsonzillo]

It came to my attention that you use repetition for the same purpose more than once in the same function and this is something wrong that consumes a lot from the processor .

This is a fraction of what I mean :

		-- tramos iniciales...
		for x=1, (totalTramosResult) do
			Table.Insert(tblInit, x, String.ToNumber(nbInicio));
			nbInicio = nbInicio+TamanoTramos;
		end
		concatInit = Table.Concat(tblInit, "\r\n", 1, TABLE_ALL);
		--Dialog.TimedMessage("Inits", concatInit, 5000, MB_ICONINFORMATION);	


		-- tramos finales...
		for d=1, (totalTramosResult) do
			nbFin = nbFin+TamanoTramos;
			Table.Insert(tblEnd, d, String.ToNumber(nbFin));
		end
		concatEnd = Table.Concat(tblEnd, "\r\n", 1, TABLE_ALL);
		--Dialog.TimedMessage("Endings", concatEnd, 5000, MB_ICONINFORMATION);	

This quick look at only and is not a complete review of your code.

I dont have this time the time for work with it, this code is old, I did not notice severe slowdown nor anybody told me any problem with this part in the cpu, I dont know if there is another way to reduce cpu dependencies, take freely this code if you're interested to get a better way to improve it. I do have 2 pcs one is an 7 year old computer and another is 2 year laptop with ryzen 9 and 32 gb + quadro 4000, one more slow the other more faster, both I did not get sever slowdown tho...

[abood1987]

take freely this code if you're interested to get a better way to improve.

I never meant that I needed this or care about this
Sorry for asking this note. Enjoy

[carsonzillo]

take freely this code if you're interested to get a better way to improve.

I never meant that I needed this or care about this
Sorry for asking this note. Enjoy

wow, are you angry dude? If you are not interested in what you wanted to say then why did you tell this, you sound childish, calm down okay? forget I told you, I dont have time cos Im busy with another priorities in real life. I dont have new plan to participate in this forum, if yes I could try, maybe this is the ast time I post something new, Anyway life is harder that here. Good luck

[dripro]

muito bom colega

[luasqlite]

Obrigado Maquina