EBDN - Community - Question & Answers
0
Undo
Votes
Hi,
What is the best way to programatically retrieve a large amount of data from a project in Engineering Base?
For example, is there any fast way to retrieve all the wires in a project, except from using a worksheet in EB API?
Using a worksheet works fine as long as it limits to a few hundreds of rows, but when it reaches
several thousands, like 10.000 rows or more, performance gets extremely poor.
If seems like performance is getting progressive bad with increasing numbers of rows to fetch.
Funny, because SQL Server normally fetch thousends (or millions) of rows in a snap..
/Michael
What is the best way to programatically retrieve a large amount of data from a project in Engineering Base?
For example, is there any fast way to retrieve all the wires in a project, except from using a worksheet in EB API?
Using a worksheet works fine as long as it limits to a few hundreds of rows, but when it reaches
several thousands, like 10.000 rows or more, performance gets extremely poor.
If seems like performance is getting progressive bad with increasing numbers of rows to fetch.
Funny, because SQL Server normally fetch thousends (or millions) of rows in a snap..
/Michael