skip to main content
Performance tuning : Oracle Eloqua bulk operations
 

Try DataDirect Cloud Now

Oracle Eloqua bulk operations

DataDirect Cloud will attempt to use bulk operations for the Account and Contact tables for queries that meet Eloqua’s requirements. Whereas, bulk operations are always used for Activity and CustomObject tables. Bulk operations are most efficient for queries that return large amounts of data for a relatively small set of columns. For example, SELECT folderid,name,country,c_website FROM Account WHERE country='Switzerland' has only four columns but many rows. DataDirect Cloud does not use bulk operations for some TOP n queries because it is usually faster to use a standard query to fetch more columns for few rows than to use a bulk operation.
Queries that qualify for using bulk operations on Account and Contact tables:
*Return 250 columns or less.
*Include at least one user-defined column.
*Return multiple rows.
*Either has no TOP n clause, or the value of n in the TOP clause must be greater than value specified in the topLimit custom property, which has a default value of 1000.
*Include only columns that the bulk interface supports. For more information, see the table below.
Table 72. Columns that cannot be retrieved using bulk operations
Account table
Contact table
accessedAt
accessedAt
createdBy
bouncebackDate
currentStatus
currentStatus
Description
createdBy
folderId
Description
Permissions
folderId
scheduledFor
Permissions
sourceTemplateId
scheduledFor
updatedBy
sourceTemplateId
subscriptionDate
updatedBy
unsubscriptionDate
The following table provides some query examples and describes why they would not take advantage of bulk operations and offers suggestions for modifying them. However, there will obviously be use cases where an application will use queries that cannot be returned using bulk operations.
Query
Description
SELECT * FROM Contact WHERE Country='Switzerland'
There are more than100 columns in the Contact table. To take advantage of bulk operations, constrain the SELECT statement to a set of 100 columns or less.
SELECT * FROM ContactList WHERE Region='East'
The ContactList table is not supported for bulk operations.
SELECT Id, C_Website FROM Account WHERE Id=17
This returns one row.
SELECT Id, C_Website FROM Contact WHERE Country='Switzerland' AND Region='EAST'
More than one criterion or comparison operators are used in the WHERE clause.
Tips:
*If a query has zero or one comparison operators (meaning one of =, <=, <, >, >=, <>) in the WHERE clause, the query will usually be processed using the bulk operations.
*If a query contains the LIKE operator in the WHERE clause, the query is not processed using the bulk operations.
* Efficient queries