Hello,
I have a database that uses a table to keep the keys of items selected to build a structure (through a treeview). Some of these structure can contain up to 5000 items.
My problem is that I need to export these structures to external systems ... not only the keys but also related infos (name, description, etc...). So in order to export I need to fetch the items table 5000 times to get these infos. This is taking a long time (even if item key is the primary on the item table).
I tried putting the table table Items in a recordset (in memory) and use the Filter method ... but it was even slower.
I'm thinking about denormalization of the table to export and put the related infos there but before that I was wondering if there was other solutions.
Is there another way to do this so I will reduce my export time ?
Ben Rail
Business Solutions
LOGI.design