pcsoft.us.windevCopyright 2026, PC SOFT24 Feb 2015 19:56:00 Z23 Feb 2015 15:13:00 ZHi I wonder if somebody can advise on the best way to utilise loopers within Webdev. Currently I get my data by means of a query and thenadd the data to a looper from the query by means of LooperAddLine. The problems I have with this approach: When there is 350 + records it takes some time to display the looper. Where the user makes changes to the data in the looper I want to update the underlying table immediately. I don't want the user to update 100 records and then he/she looses an internet connection or forgets to click an update button. Even if I use a looper directly linked to a query the speed to load 350 + records is slow. Then to update the records as the changes are made takes as long as the above approach. I have also linked the looper to a variable but the initial populating of the variable and display of the looper takes the same time as looperaddline. I don't use the loopers with pagers as it's irritating to go page next, next, next if you don't know where the record is you are looking for and there are 40-50 pages. It's much faster to just scroll down a looper if it is sorted. I have tried changing from Classic to Ajax loopers but don't really see a difference in speed unless I'm not handling the looper code correctly. With a new client I have cases where 500 + records must be displayed and the performance is terrible. Any suggestions, as always, are much appreciated. Ericus Steyn30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50615-wb18-looper-load-speed/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50615-wb18-looper-load-speed-50665/read.awp24 Feb 2015 19:56:00 ZHi Piet Yes the looper with all this data is a waste but I am really using this to handle cashbooks. The customer's bank s…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50615-wb18-looper-load-speed-50665/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50615-wb18-looper-load-speed-50665/read.awp[WB18] Looper load speedguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50615-wb18-looper-load-speed-50645/read.awp24 Feb 2015 09:39:00 ZHi Ericus, Using a looper to show all data from all records is wasting resources. A user can only look at and modify one dat…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50615-wb18-looper-load-speed-50645/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50615-wb18-looper-load-speed-50645/read.awp[WB18] Looper load speedfromwebpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50615-wb18-looper-load-speed-50636/read.awp24 Feb 2015 01:49:28 ZHi Rudolf that won't work in webdev... the preparation is done on the server, then the whole page is sent to the browser an…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50615-wb18-looper-load-speed-50636/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50615-wb18-looper-load-speed-50636/read.awp[WB18] Looper load speedinfopcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50615-wb18-looper-load-speed-50625/read.awp23 Feb 2015 19:38:27 ZHi, A little trick that works in WinDev (and maybe also in WebDev) is to make the looper invisible when filling and only show…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50615-wb18-looper-load-speed-50625/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50615-wb18-looper-load-speed-50625/read.awp[WB18] Looper load speedguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50615-wb18-looper-load-speed-50621/read.awp23 Feb 2015 16:48:00 ZThanks Fabrice I will give it a try. Ericus Steynhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50615-wb18-looper-load-speed-50621/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50615-wb18-looper-load-speed-50621/read.awp[WB18] Looper load speedguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50615-wb18-looper-load-speed-50617/read.awp23 Feb 2015 15:43:00 ZHi Ericus the first thing to consider is that all you are describing is a perfectly normal behavior... For 350 records, the s…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50615-wb18-looper-load-speed-50617/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/50615-wb18-looper-load-speed-50617/read.awp[WB18] Looper load speed