# createDataSourceByQuery() \_sv\_inmem storage location

**URL:** <https://forum.servoy.com/t/createdatasourcebyquery-sv-inmem-storage-location/14018>\
**Category:** Classic Servoy\
**Created:** [May 20, 2011, 9:03am UTC](https://forum.servoy.com/t/createdatasourcebyquery-sv-inmem-storage-location/14018 "2011-05-20T09:03:27Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![servoydevguy](https://avatars.discourse-cdn.com/v4/letter/s/aeb1de/32.png) [@servoydevguy](https://forum.servoy.com/u/servoydevguy)\
**Post date:** [May 20, 2011, 9:03am UTC](https://forum.servoy.com/t/createdatasourcebyquery-sv-inmem-storage-location/14018/1 "2011-05-20T09:03:27Z")

</div>

I am creating a custom foundset in an attempt to locally store configuration settings. I would like to hit the database only once to gather the data and then search it locally. But, I am noticing in the performance logs and trace that when a find() is performed on this custom foundset, it “seems” to be going back to the server everytime or at least it is being logged server side. So my question is, is the _sv\_inmem database and temp_ tables stored client side or are they in fact stored back on the server?

Here is the code I am using:

```auto
var _defConfigDS = databaseManager.createDataSourceByQuery("sw_defconfigs",globals.adminServer,_query,_args,-1);
globals.sw_defConfigFS = databaseManager.getFoundSet(_defConfigDS);

```

---

<div class="post-metadata">

**Author:** ![servoydevguy](https://avatars.discourse-cdn.com/v4/letter/s/aeb1de/32.png) [@servoydevguy](https://forum.servoy.com/u/servoydevguy)\
**Post date:** [May 24, 2011, 9:51am UTC](https://forum.servoy.com/t/createdatasourcebyquery-sv-inmem-storage-location/14018/2 "2011-05-24T09:51:07Z")

</div>

Anyone? Servoy? ![:wink:]( "Wink")

---

<div class="post-metadata">

**Author:** ![rvanderburg](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/rvanderburg/32/5076_2.png) [@rvanderburg](https://forum.servoy.com/u/rvanderburg)\
**Post date:** [May 24, 2011, 10:37am UTC](https://forum.servoy.com/t/createdatasourcebyquery-sv-inmem-storage-location/14018/3 "2011-05-24T10:37:52Z")

</div>

The datasource you are creating is a in memory database which runs serverside and behaves the same as all other databases you have connected.  
You cannot however run you own rawsql agianst it

---

<div class="post-metadata">

**Author:** ![servoydevguy](https://avatars.discourse-cdn.com/v4/letter/s/aeb1de/32.png) [@servoydevguy](https://forum.servoy.com/u/servoydevguy)\
**Post date:** [May 24, 2011, 11:19am UTC](https://forum.servoy.com/t/createdatasourcebyquery-sv-inmem-storage-location/14018/4 "2011-05-24T11:19:46Z")

</div>

Thanks. That’s what I needed to confirm.