Supply Demand vs select
来源:互联网 发布:畅捷通软件怎么用 编辑:程序博客网 时间:2024/05/12 12:36
SELECT:
SELECT * FROM SBOOK INTO SBOOK_WA UP TO 10 ROWS.
SELECT SINGLE AIRPFROM AIRPTO INTO (AP1, AP2)
FROM SPFLI
WHERE CARRID = SBOOK_WA-CARRID
AND CONNID = SBOOK_WA-CONNID.
SELECT SINGLE NAME INTO NAME1 FROM SAIRPORT
WHERE ID = AP1.
SELECT SINGLE NAME INTO NAME2 FROM SAIRPORT
WHERE ID = AP2.
ENDSELECT.
Context (for durable data) :
SELECT * FROM SBOOK INTO SBOOK_WA UP TO 10 ROWS.
SUPPLY CARRID = SBOOK_WA-CARRID
CONNID = SBOOK_WA-CONNID
TO CONTEXT TRAV1.
DEMAND AIRPFROM = AP1
AIRPTO = AP2
NAME_FROM = NAME1
NAME_TO = NAME2
FROM CONTEXT TRAV1.
ENDSELECT.
Documentation
Context advantages:
- no double fetch by DEMAND: 1. fetch, 2. get from buffer
- more performance (best SELECT-statement)
- better survey of code
- Supply Demand vs select
- Epoll vs Poll vs Select
- select() vs pselect()
- select VS epoll
- ORALCE: Select into VS Insert into select
- 海量接入-epoll vs poll vs select
- poll vs select vs event-based
- Demand management
- epoll VS select之我见
- win7 "ClassFactory cannot supply requested class" in VS 2008的错误解决方法
- ORALCE: Select into VS Insert into select(真的晕)
- SELECT SINGLE vs. UP TO 1 ROWS
- Windows Vista On Demand
- 刚性需求 rigid demand
- game on demand
- 视频点播 video on demand
- Demand Side Platform
- Loading Views On Demand
- 外排序思路总结
- Using A Subquery
- 1753
- 团队建设
- Google C++编程规范(二)————(作用域篇)
- Supply Demand vs select
- ibatis学习笔记(五)>>>>>>>ibatis和Spring整合实例
- VMware虚拟机安装Ubuntu不能上网的问题解决方案
- mysql常用命令集
- CCS编程入门
- WEKA入门教程
- Secondary indices
- hello world for test
- 如何得到jenkins build number?