DataService Studio APIs that query MaxCompute tables can face high latency by default. Two acceleration solutions reduce query execution time from minutes to seconds: Acceleration Service (based on Hologres external tables) and MCQA (MaxCompute Query Acceleration). This topic explains how to choose between them and configure each one.
Choose an acceleration solution
Both solutions target MaxCompute data and are available in four regions: China (Beijing), China (Hangzhou), China (Shanghai), and China (Shenzhen).
| Acceleration Service | MCQA | |
|---|---|---|
| How it works | Maps a Hologres external table to a MaxCompute table schema. Queries run through Hologres without exporting data from MaxCompute. | Routes queries through the MaxCompute Query Acceleration (MCQA) engine, reducing small- and medium-sized query execution time from minutes to seconds. |
| When to use | Your API targets a fixed MaxCompute table and you need stable, low-latency responses. | Your API runs ad-hoc or variable queries and you want faster execution without pre-configuring table mappings. |
| Resource group | Shared resource group for DataService Studio | Exclusive resource group only |
| MaxCompute project type | Any | Subscription or pay-as-you-go |
| Setup steps | 1. Add an acceleration item. 2. Configure the API. | Configure the API only. |
| Additional cost | Charged when using the shared resource group to call DataService Studio APIs (from March 1, 2023). See DataService Studio billing. | See your MaxCompute project billing for details. |
Use the Acceleration Service solution
Limits
-
Each acceleration item maps to exactly one data table.
-
Each data table can have only one acceleration item.
-
If you select a table that already has an acceleration item, initialization fails.
Step 1: Add an acceleration item
-
Log on to the DataWorks console. In the top navigation bar, select the target region. In the left-side navigation pane, choose Data Analysis and Service > DataService Studio. Select the target workspace and click Go to DataService Studio.
-
In the left-side navigation pane, click the
icon to open the Acceleration Service page. -
In the upper-right corner, click Add Acceleration Item.
-
In the Add Acceleration Item dialog box, configure the following parameters.
Parameter Description Acceleration Solution Select Hologres Foreign Table. Hologres maps its external table schema to your MaxCompute table, so queries run without exporting MaxCompute data. No separate Hologres compute engine instance is required—an existing instance is used automatically. Datasource Type Select MaxCompute (ODPS). Table Name Select the MaxCompute data source and data table. To add multiple tables at once, click Add Table. You can add up to 10 MaxCompute data tables per operation. 
-
Click OK. When the Status column shows Initialize Succeeded, click Close.
Step 2: Configure an API
-
Find the target API and double-click its name.
-
In the Select Table section of the API configuration tab, set the following parameters.
After you set the Acceleration Method parameter to Acceleration Service, the Acceleration Service solution is used to accelerate data queries performed by the API. On the Acceleration Service page, you can view the acceleration items associated with the API. If the API was created using the code editor, it supports only single-table queries and requires Hologres syntax in the editor.Parameter Value Datasource Type MaxCompute (ODPS) Datasource Name The data source for which you added an acceleration item Acceleration Method Acceleration Service Table Name Select a table marked with Accelerated 
-
Configure the remaining API parameters. See Create an API by using the codeless UI or Create an API by using the code editor.
Step 3: View and manage acceleration items
On the Acceleration Service page, view all acceleration items and manage them using the Actions column.
| Action | Description |
|---|---|
| Discard | Removes the acceleration item. APIs associated with the discarded item return errors. Before discarding, check which APIs use the item and unpublish them. |
| View API | Click the More icon and select View API to see APIs associated with the acceleration item. |
Use the MCQA solution
MCQA requires only one configuration step—no acceleration items needed.
Configure an API
-
Find the target API and double-click its name.
-
In the Select Table section of the API configuration tab, set the following parameters.
Parameter Value Datasource Type MaxCompute (ODPS) Datasource Name The target MaxCompute data source Acceleration Method MCQA Table Name The target MaxCompute data table 
-
Configure the remaining API parameters. See Create an API by using the codeless UI or Create an API by using the code editor.
For background on how MCQA works, see MCQA overview.