---
sourceDocument: Xanadu API Reference
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/xanadu/api-reference

 Release :

    - xanadu

ft:locale :

    - en-US

ft:publication_title :

    - Xanadu API Reference

ft:clusterId :

    - crapiref

bundleId :

    - crapiref

workflow :

    - Creator


---

# Configure the ODBC driver for large data sets

# Configure the ODBC driver for large data sets {#ariaid-title1}

* Release version: Xanadu
* 
* Updated August 1, 2024
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

You can set two ODBC driver properties to deal with errors you receive when using
queries that return large amounts of data.

## Before you begin

You must have administrator-level access for the Windows computer on which you want to configure the ODBC driver for large data sets.

## About this task

These properties are set using the ODBC Management Console available on Windows operating systems. For more information, see [ODBC management console properties](https://servicenow-prod.fluidtopics.net/CW2ZL2qS12mUQQVU~5pcMA#r_SettingODBCProperties__ODBC_mgmt_console_properties).

## Procedure

1. In Windows, navigate to StartProgramsServiceNow ODBCManagement Console.
2. Navigate to Data Source SettingsServiceNowIP Parameters.
3. Set the Timeout property to be more than the glide.soap.request_processing_timeout.odbc value in seconds.  
   ODBC makes SOAP calls on the instance. The glide.soap.request_processing_timeout.odbc system property is the timeout for the ODBC driver.
4. Navigate to ServicesService SettingsSQL Engine Parameters.
5. Increase the ServiceSQLDiskCacheMaxSize property.  
   Typically, when running a query that returns 50,000 rows, the default value of 200 MB must be increased.
{#configure-odbc-large-data-sets__steps_ks1_nhv_s1b}

*[\>]: and then