pcsoft.us.windevCopyright 2026, PC SOFT27 Sep 2017 09:49:06 Z9 Feb 2012 14:49:14 ZHello everyone! I need to manage DB tables (*.FIC files) with a lot of records, I am talking about 1.000.000 records more or less. When I attempt to filter on a specific column using WDMAP then it takes a lot of time because, for example, before searching for a particular record it sorts all the records in the table according to that specific key. With so many records WDMAP crashes very often. So instead of linking a table of my application with this file I wanted to fill my table application by programming browsing the file from the top to the bottom and adding each record to the table with TableAddLine. Unfortunately with so many records it takes a long time too. Can someone suggest a method to manage big tables in a faster way? Kindest Regards Antonino30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/35735-table-with-lot-records/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)PETR_Kpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/35735-table-with-lot-records-62763/read.awp27 Sep 2017 09:49:06 ZHello Antonino, I wonder if and how you solved your problem because I have something similar. Would you share your solution w…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/35735-table-with-lot-records-62763/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/35735-table-with-lot-records-62763/read.awpDB table with a lot of recordsantonino.neripcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/35735-table-with-lot-records-35757/read.awp14 Feb 2012 15:08:56 ZHi Andy, I want to thank you for your tip. I'll try to put your ideas together and come out with an acceptable solution! …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/35735-table-with-lot-records-35757/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/35735-table-with-lot-records-35757/read.awpDB table with a lot of recordsandypcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/35735-table-with-lot-records-35751/read.awp13 Feb 2012 14:44:55 ZMorning What I did was use 2 procedures.. One runs in background to further fill the data, and the main one sets the first …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/35735-table-with-lot-records-35751/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/35735-table-with-lot-records-35751/read.awpDB table with a lot of recordsantonino.neripcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/35735-table-with-lot-records-35748/read.awp13 Feb 2012 10:11:14 ZHi Riebens, first of all I want to thank you for your time and care. So your suggestion is to display just the data they (…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/35735-table-with-lot-records-35748/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/35735-table-with-lot-records-35748/read.awpDB table with a lot of recordsRiebenspcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/35735-table-with-lot-records-35740/read.awp11 Feb 2012 06:21:46 ZHi You will need to create a query and fill your table programatically. You will need to ask yourself .. Why do i displa…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/35735-table-with-lot-records-35740/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/35735-table-with-lot-records-35740/read.awpDB table with a lot of records