# Toad Data Point Insert Query Issue

**URL:** <https://forums.toadworld.com/t/toad-data-point-insert-query-issue/49435>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [March 29, 2020, 3:41pm UTC](https://forums.toadworld.com/t/toad-data-point-insert-query-issue/49435 "2020-03-29T15:41:14Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![toad.user](https://avatars.discourse-cdn.com/v4/letter/t/e19b73/32.png) [@toad.user](https://forums.toadworld.com/u/toad.user)\
**Post date:** [March 29, 2020, 3:41pm UTC](https://forums.toadworld.com/t/toad-data-point-insert-query-issue/49435/1 "2020-03-29T15:41:14Z")

</div>

We are attempting to use TDP to load 30M+ records from a file export from Oracle and then loading the data into Teradata. However, if we use the import wizard it is maxing out the spool capacity we have and we need to know if the wizard is executing multiple inserts and if so how we minimize that so we're not pushing the available spool capacity which results in a system abort when we hit threshold. We know there is a fetch threshold in the options, perhaps that is what is happening with the insert and we need to increase it?

![image](https://global.discourse-cdn.com/quest/original/2X/f/f5644f614c0abe3898e697a1eff7abe02166155b.png)

---

<div class="post-metadata">

**Author:** ![dan](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/dan/32/12882_2.png) [@dan](https://forums.toadworld.com/u/dan)\
**Post date:** [March 29, 2020, 10:05pm UTC](https://forums.toadworld.com/t/toad-data-point-insert-query-issue/49435/2 "2020-03-29T22:05:30Z")

</div>

Hi,  
I'm really not sure Toad has been made with such large numbers in mind. We did some tasks with 10M databases maximum, I personally tried with 10M of inserts and it worked fine and reasonably quickly. Generally it's recommended to keep it under a milion of records.  
I'll consult the devs if they know of any specific limitation for Teradata imports.

---

<div class="post-metadata">

**Author:** ![Filip.Cevela](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/filip.cevela/32/200_2.png) [@Filip.Cevela](https://forums.toadworld.com/u/Filip.Cevela)\
**Post date:** [March 30, 2020, 8:10am UTC](https://forums.toadworld.com/t/toad-data-point-insert-query-issue/49435/3 "2020-03-30T08:10:03Z")

</div>

Hi,

import wizard execute multiple insert statements with bloc size. You should be able to set this block before you start the Import. In your case you should disable 'Optimize bloc size' and try to specify some of your limits.

 ![image](https://global.discourse-cdn.com/quest/original/2X/0/0a675a0ec7bbd206e360f4bd16c531dcee0a2686.png)

---

<div class="post-metadata">

**Author:** ![toad.user](https://avatars.discourse-cdn.com/v4/letter/t/e19b73/32.png) [@toad.user](https://forums.toadworld.com/u/toad.user)\
**Post date:** [April 1, 2020, 3:47pm UTC](https://forums.toadworld.com/t/toad-data-point-insert-query-issue/49435/4 "2020-04-01T15:47:37Z")

</div>

Thanks, that will help greatly.

---

<div class="post-metadata">

**Author:** ![toad.user](https://avatars.discourse-cdn.com/v4/letter/t/e19b73/32.png) [@toad.user](https://forums.toadworld.com/u/toad.user)\
**Post date:** [April 1, 2020, 3:51pm UTC](https://forums.toadworld.com/t/toad-data-point-insert-query-issue/49435/5 "2020-04-01T15:51:25Z")

</div>

I updated the block size, which was set to optimize, and noticed the insert row count was the same as when it was set to optimize. How can we confirm the block size is as specified? It appears to be updating in increments of 10K in the background processes. This is key to reducing the number of queries executed that pushes our present spool capacity.