# Can't read splayed tables bigger than 38 GB

**URL:** <https://forum.kx.com/t/cant-read-splayed-tables-bigger-than-38-gb/9595>\
**Category:** Community Support\
**Tags:** kdb-and-q\
**Created:** [March 9, 2015, 4:53pm UTC](https://forum.kx.com/t/cant-read-splayed-tables-bigger-than-38-gb/9595 "2015-03-09T16:53:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![A\_L\_V](https://avatars.discourse-cdn.com/v4/letter/a/f4b2a3/32.png) [@A\_L\_V](https://forum.kx.com/u/A_L_V)\
**Post date:** [March 9, 2015, 4:53pm UTC](https://forum.kx.com/t/cant-read-splayed-tables-bigger-than-38-gb/9595/1 "2015-03-09T16:53:00Z")

</div>

Have folder structure: C:/dir/2014.01.01/exampleTable C:/dir/2014.01.01/sym … do \cd dir/2014.01.01 exampleTable:get:`exampleTable If folder less than 38 GB typing exapleTable or a more specific query will work, else get +… error. Is there a way to further splay / partition the table to reduce size?

---

<div class="post-metadata">

**Author:** ![charlie1](https://avatars.discourse-cdn.com/v4/letter/c/ec9cab/32.png) [@charlie1](https://forum.kx.com/u/charlie1)\
**Post date:** [March 9, 2015, 5:16pm UTC](https://forum.kx.com/t/cant-read-splayed-tables-bigger-than-38-gb/9595/2 "2015-03-09T17:16:00Z")

</div>

\>C:/dir/2014.01.01/exampleTable  
\>C:/dir/2014.01.01/sym

is unusual; you should have just the one sym file at the root

C:/dir/sym

or you’ll run into other problems later.

And rather than loading tables in the same way as several emails ago, just use

\l c:/dir

and then query using

select&nbsp;… from&nbsp;exampleTable where date=2014.01.01

You can have partitions split into segments -

http://code.kx.com/wiki/JB:KdbplusForMortals/segments

For 32bit, you need to get each table in each partition to less than ~500MB.

---

<div class="post-metadata">

**Author:** ![A\_L\_V](https://avatars.discourse-cdn.com/v4/letter/a/f4b2a3/32.png) [@A\_L\_V](https://forum.kx.com/u/A_L_V)\
**Post date:** [March 11, 2015, 9:10am UTC](https://forum.kx.com/t/cant-read-splayed-tables-bigger-than-38-gb/9595/3 "2015-03-11T09:10:00Z")

</div>

Thank you. There seems to be no imediately obvious way we can segment it to 500 mb. A single instrument on a single day may have more data than that :(

---

<div class="post-metadata">

**Author:** ![A\_L\_V](https://avatars.discourse-cdn.com/v4/letter/a/f4b2a3/32.png) [@A\_L\_V](https://forum.kx.com/u/A_L_V)\
**Post date:** [March 11, 2015, 10:08am UTC](https://forum.kx.com/t/cant-read-splayed-tables-bigger-than-38-gb/9595/4 "2015-03-11T10:08:00Z")

</div>

\* immediate