# ifcSQL is on github

**URL:** <https://forums.buildingsmart.org/t/ifcsql-is-on-github/3743>\
**Category:** Serializations\
**Created:** [June 21, 2021, 5:06am UTC](https://forums.buildingsmart.org/t/ifcsql-is-on-github/3743 "2021-06-21T05:06:58Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![bsbock](https://sea2.discourse-cdn.com/flex016/user_avatar/forums.buildingsmart.org/bsbock/32/435_2.png) [@bsbock](https://forums.buildingsmart.org/u/bsbock)\
**Post date:** [November 7, 2021, 12:48pm UTC](https://forums.buildingsmart.org/t/ifcsql-is-on-github/3743/6 "2021-11-07T12:48:15Z")

</div>

Here you find some explanations how the stored procedures [app].[ToIfcStepFromProjectId] or [cp].[ToIfcStep] works:

> [@Store, modify and retrieve ifc-data with ifcSQL](https://forums.buildingsmart.org/t/store-modify-and-retrieve-ifc-data-with-ifcsql/1558/3):
>
> These are the secrets of ToIfcStepFromProjectId: Select the project from the Id-argument of ToIfcStepFromProjectId, so the view of the current project retrieves only the entities of this project Fill the step-header with the informations of the current-project-view [cp].[Project] and print it Iterate via CURSOR over all entities and call a function [ToIfcStepLine] für every entity 3.1 Select the local ifc-id from the current entity for this project 3.2 Select the name of the type of the curr…

Creating a Stepfile with the above mentioned stored procedures use a lot of nestet queries. So the time-costs increase exponential with the model size.  
Maybe you can speed it up with temporary tables and other methods. If you set some timestamp-outputs, you will find out where the bottle necks are. The point is, that all this methods ends in a procedural way.  
The fast procedural way is used in IFC#. See [https://github.com/IfcSharp/IfcSharpApps/tree/master/IfcSql/from\_ifcSQL](https://github.com/IfcSharp/IfcSharpApps/tree/master/IfcSql/from_ifcSQL)

To the importing speed: The IFC#-Api use a bulk-Insert method, wich is much faster than INSERT-statements.  
See CurrentModel.ToSql(…) in [https://github.com/IfcSharp/IfcSharpApps/tree/master/IfcSharp/hello\_project](https://github.com/IfcSharp/IfcSharpApps/tree/master/IfcSharp/hello_project)

If this is not fast enough, you can try to work with temporay tables without restrictions and transfer it on server-side to the ifcSQL-tables in a second step.  
Hope this helps.

---

_[View the full topic](https://forums.buildingsmart.org/t/ifcsql-is-on-github/3743)._
