FW: query performance slow

From: Bob Pisani <bpisani(at)schonfeld.com>
Date: Thu Jul 26 2007 - 10:22:42 EDT

CREATE TABLE ORDERS

(          
          REC_TYPE CHAR(6),
          EVENT_TYPE CHAR(3),
          ACTION_TYPE CHAR(1),
          FIRM_ROEID VARCHAR(5),
          COR_DEL_TS VARCHAR(5),
          RJCT_RESUB VARCHAR(5),
          ORD_REC_MPID CHAR(4),
          ORD_REC_DATE DATETIME,
          ORDER_ID  VARCHAR(14),
          ROUTE_MPID CHAR(4),
          ROUTE_ORDID VARCHAR(14),
          ORD_REC_TIME DATETIME,
          METHOD_CODE CHAR(1),
          SYMBOL VARCHAR(10),
          BUY_SELL CHAR(3),
          LMT_PRICE FLOAT(8,2),
          LMT_CODE CHAR(3),
          STP_PRICE FLOAT(8,2),
          FILL_CODE VARCHAR(6),
          EXPIRE_DATE DATETIME,
          EXPIRE_TIME DATETIME,
          DNR_DNI VARCHAR(5),
          ONE_HANDLE VARCHAR(5),
          TWO_HANDLE VARCHAR(5),
          THREE_HANDLE VARCHAR(5),
          FOUR_HANDLE VARCHAR(5),
          FIVE_HANDLE VARCHAR(5),
          REC_TERMID VARCHAR(5),
          REC_DEPTID VARCHAR(5),
          ORIG_DEPTID VARCHAR(5),
          ACCT_CODE CHAR(1),
          PRG_TRD_CODE CHAR(1),
          ARB_CODE CHAR(1),
          SENT_ROUTE_ORDID VARCHAR(10),
          SENT_TO_MPID CHAR(4),
          ORDER_TIME DATETIME,
          SHARES INTEGER,
          ROUTE_MTHD CHAR(1),
          BUNCH_ORDER VARCHAR(5),
          MEMBER_TYPE_CODE CHAR(1),
          DESTINATION_CODE CHAR(4),
          ECN_FLAG VARCHAR(5),
          CXL_TIME_STAMP DATETIME,
          CXL_BY_FLAG CHAR(1),
          SHARES_QUANTITY INTEGER,
          RCVD_BY_DESK_ID VARCHAR(5),
          DESK_RCVD_TIMESTAMP DATETIME,
          DESK_TYPE_CODE VARCHAR(5),
          DESK_SHC_1 VARCHAR(5),
          DESK_SHC_2 VARCHAR(5),
          DESK_SHC_3 VARCHAR(5),
          DESK_SHC_4 VARCHAR(5),
          DESK_SHC_5 VARCHAR(5),
          TMO_TIMESTAMP DATETIME,
          REC_DATE DATETIME,
Do you need help?
In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software:
Learn more about Pantek's Technical Support offerings
Place an order for 24/7/365 Technical Support here
Learn more about Pantek, who we are, and what we do
Chat with a Live Operator
Related lists.mysql.com Links
announce
benchmarks
bugs
certification
cluster
commits
dotnet
gui-tools
internals
java
maxdb
myodbc
mysql
mysqldoc
packagers
perl
plusplus
replication
win32
Request more information about Pantek
          PRIMARY KEY(ORDER_TIME, ORDER_ID)

)
TABLESPACE TS_DATA STORAGE DISK
ENGINE NDB; -----Original Message-----
From: Brian Moon [mailto:brianm@dealnews.com] Sent: Wednesday, July 25, 2007 6:12 PM
To: Bob Pisani
Cc: 'cluster@lists.mysql.com'
Subject: Re: query performance slow

Can we see the full create table please?

--

Brian Moon
Senior Developer

---

http://dealnews.com/
It's good to be cheap =)

This communication is for informational purposes only. It is not intended as an offer or solicitation or as an official confirmation. Market prices and other information are not guaranteed as to completeness or accuracy and are subject to change without notice. Schonfeld Group reserves the right to monitor and review the content of all messages sent to or from this e-mail address.

--

MySQL Cluster Mailing List
For list archives: http://lists.mysql.com/cluster To unsubscribe: http://lists.mysql.com/cluster?unsub=lists@pantek.com Received on Thu Jul 26 10:26:17 2007