Re: Poor performance vs. MSSQL with JDBC
Posted by: David Wynter
Date: April 06, 2005 07:51AM
Date: April 06, 2005 07:51AM
The cmd line client has a limitation on the buffer size allowed, (my compound queries add up to around 21KB each) and it uses the ; to execute. Since my compounrd statement has 20 queries and therefore 20 ';' in it I am not sure it is possible to try it with mysql cmd line.
I tried the MySQL Query Browser too, it too has a buffer limit on the size of the query it seems, at least on one line it does. This is the second string passed to Statement.execute.
INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 2776, null, null, 18481, null, 'Top Glory Intl', null, 'Top Glory International Holdings Ltd', 114728, 539, '873855', 'HK0268010771', null, 'CS', 'HKG', 'TOP GLORY INTL STK', null, '0268.HK^H03', null, 'HKD', null, 44, null, null, null, 902569, '0', null, 6806467, 'HKG', null, null, 'WHITEN', null, null, null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 5, null, null, 33714, null, 'Baring Pacific', 'BPFH.HK', 'Baring Pacific Fund', 177204, null, null, null, null, 'CS', 'HKG', 'BARING PACIFIC STK', null, 'BPFH.HK^C91', null, 'HKD', null, 62, null, null, null, null, '0', null, null, 'HKG', null, null, '$9BARPC', null, null, null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 2776, null, 877979, 12475, null, 'Burwill', '0024.HK', 'Burwill Holdings Ltd', 254294, 188, 'A0B60J', 'BMG1808K1009', null, 'CS', 'HKG', 'BURWILL STK', null, '0024.HK', null, 'HKD', null, 59, 24, null, null, 915752, '1', null, null, 'HKG', null, null, 'BRWILL', 10911800, '6155948', null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 2776, null, 870986, 18496, null, 'Cathay Pacific', '0293.HK', 'Cathay Pacific Airways Ltd', 114764, 591, '870986', 'HK0293001514', null, 'CS', 'HKG', 'CATHAY PACIFIC STK', null, '0293.HK', null, 'HKD', null, 56, 293, null, null, 903694, '1', null, 7030072, 'HKG', null, null, 'CATHP', 5116236, '6179755', null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 5, null, 897920, 12524, null, 'Sun Man Tai', '0433.HK', 'Sun Man Tai Holdings Co Ltd', 103771, 875, 'A0BKKY', 'BMG8582W1192', null, 'CS', 'HKG', 'MKI STK', null, '0206.HK^J95', null, 'HKD', null, 62, null, 'G8582W119', null, 935455, '0', null, null, 'HKG', null, null, 'KOKT', 10958679, null, null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 2776, null, null, 18503, null, 'Chi Cheung', '0112.HK', 'Chi Cheung Investment Co Ltd', 114772, 862, '249819', 'HK0112012916', null, 'CS', 'HKG', 'CHI CHEUNG STK', null, '0112.HK', null, 'HKD', null, 64, 112, null, null, null, '1', null, null, 'HKG', null, null, 'CHICH', null, '6614557', null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 2776, null, null, 40547, null, 'Frankie Dominion', '0704.HK', 'Frankie Dominion International Ltd', 701293, 345, '594725', 'BMG3657Q1050', null, 'CS', 'HKG', 'FRANKIE DOMINION STK', null, '0704.HK', null, 'HKD', null, 41, 704, 'G3657Q105', null, 924062, '1', null, null, 'HKG', null, null, 'DOMFRK', 4582608, '6350129', null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 2776, null, 884434, 18498, null, 'CDW Intl', '0481.HK', 'CDW International Ltd', 1401940, null, '884434', 'KYG1988U1004', null, 'CS', 'HKG', 'CDW INTL STK', null, '0481.HK^D97', null, 'HKD', null, 47, null, 'G1988U100', null, 922118, '0', null, null, 'HKG', null, null, 'HKRES', 4578350, null, null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 2776, null, 877553, 12534, null, 'Century City', '0355.HK', 'Century City International Holdings Ltd', 103792, 536, '877553', 'BMG2020F1014', null, 'CS', 'HKG', 'CENTURY CITY STK', null, '0355.HK', null, 'HKD', null, 64, 355, 'G2020F101', null, 912888, '1', null, null, 'HKG', null, null, 'CCHOL', null, '6185150', null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 5, null, null, 12549, null, 'China Entert', '130.HK', 'China Entertainment and Land Investment Holdings Ltd', 910555, null, null, null, null, 'CS', 'HKG', 'CHINA ENTMT STK', null, 'CELH.HK^I92', null, 'HKD', null, 64, null, null, null, null, '0', null, null, 'HKG', null, null, 'CHELI', null, null, null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 2776, null, 877535, 12551, null, 'Chinese Est H', '0127.HK', 'Chinese Estates Holdings Ltd', 103815, 862, 'A0CANZ', 'BMG2108M1762', null, 'CS', 'HKG', 'CHINESE EST H STK', null, '0127.HK', null, 'HKD', null, 64, 127, null, null, 911677, '1', null, null, 'HKG', null, null, 'CHESTS', 4580346, '6191180', null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 2776, null, 881043, 12482, null, 'Cafe De Coral', '0341.HK', 'Cafe de Coral Holdings Ltd', 103723, 539, '881043', 'BMG1744V1037', null, 'CS', 'HKG', 'CAFE DE CORAL STK', null, '0341.HK', null, 'HKD', null, 53, 341, 'G1744V103', null, 902774, '1', null, null, 'HKG', null, null, 'WELLNT', 4578295, '6160953', null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 5, null, 874483, 12550, null, 'China & Eastrn', null, 'China & Eastern Investment Co Ltd', 114773, null, '874483', 'HK0110000632', null, 'CS', 'HKG', 'CHINA & EASTERN STK', null, '0110.HK^A96', null, 'HKD', null, 62, null, null, null, 903239, '0', null, 7612173, 'HKG', null, null, 'CHNEAS', 4578643, '6190808', null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 2776, null, 885542, 18508, null, 'Grand Field Gp', '0115.HK', 'Grand Field Group Holdings Ltd', 114779, 862, '723772', 'BMG4054H1108', null, 'CS', 'HKG', 'GRAND FIELD GP STK', null, '0115.HK', null, 'HKD', null, 11, 115, 'G4054H110', null, null, '1', null, null, 'HKG', null, null, 'CHINTO', null, '6268512', null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 2776, null, 863343, 18521, null, 'Cross-Har Hold', '0032.HK', 'Cross-Harbour (Holdings) Ltd', 114795, 583, '863343', 'HK0032009356', null, 'CS', 'HKG', 'CROSS HAR HOLD STK', null, '0032.HK', null, 'HKD', null, 52, 32, null, null, 900698, '1', null, 6513245, 'HKG', null, null, 'CHT', null, '6235367', null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 2776, null, 882231, 12557, null, 'Chuang's Intl', '0367.HK', 'Chuang's Consortium International Ltd', 103824, 862, '882231', 'BMG2122V1458', null, 'CS', 'HKG', 'CHUANG'S INTL STK', null, '0367.HK', null, 'HKD', null, 64, 367, 'G2122V145', null, 911190, '1', null, 7145260, 'HKG', null, null, 'CHNG', null, '6197401', null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 2776, null, 877257, 39654, null, 'Chevalier Intl', '0025.HK', 'Chevalier International Holdings Ltd', 254301, 137, '461279', 'BMG2097Z1471', null, 'CS', 'HKG', 'CHEVALIER INTL STK', null, '0025.HK', null, 'HKD', null, 32, 25, null, null, 985214, '1', null, 7281060, 'HKG', null, null, 'CHEVHK', 4595807, '6616984', null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 2776, null, null, 39653, null, 'Chevalier Itech', '0508.HK', 'Chevalier iTech Holdings Ltd', 701135, 253, '553166', 'BMG209831210', null, 'CS', 'HKG', 'CHEVALIER ITECH STK', null, '0508.HK', null, 'HKD', null, 55, 508, null, null, 919875, '1', null, 7488396, 'HKG', null, null, 'CHEVA', 17151533, '6617006', null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 5, null, null, 18511, null, 'Dynamic Hldgs', '0029.HK', 'Dynamic Holdings Ltd', 114783, 862, null, null, null, 'PD', 'HKG', 'DYNAMIC PR', null, 'CHWA_p.HK^C90', null, 'HKD', null, 64, null, null, null, null, '0', null, null, 'HKG', null, null, 'CWSE', null, null, null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 2776, null, null, 18511, null, 'Dynamic Hldgs', '0029.HK', 'Dynamic Holdings Ltd', 114782, 862, '789635', 'BMG2889K1678', null, 'CS', 'HKG', 'DYNAMIC HLDGS STK', null, '0029.HK', null, 'HKD', null, 64, 29, 'G2889K167', null, null, '1', null, 7225587, 'HKG', null, null, 'CWSE', null, '6290117', null);
Any way I can have some diagnostics on whar MySQL server is doing with this 2nd Statement execute?
David
I tried the MySQL Query Browser too, it too has a buffer limit on the size of the query it seems, at least on one line it does. This is the second string passed to Statement.execute.
INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 2776, null, null, 18481, null, 'Top Glory Intl', null, 'Top Glory International Holdings Ltd', 114728, 539, '873855', 'HK0268010771', null, 'CS', 'HKG', 'TOP GLORY INTL STK', null, '0268.HK^H03', null, 'HKD', null, 44, null, null, null, 902569, '0', null, 6806467, 'HKG', null, null, 'WHITEN', null, null, null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 5, null, null, 33714, null, 'Baring Pacific', 'BPFH.HK', 'Baring Pacific Fund', 177204, null, null, null, null, 'CS', 'HKG', 'BARING PACIFIC STK', null, 'BPFH.HK^C91', null, 'HKD', null, 62, null, null, null, null, '0', null, null, 'HKG', null, null, '$9BARPC', null, null, null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 2776, null, 877979, 12475, null, 'Burwill', '0024.HK', 'Burwill Holdings Ltd', 254294, 188, 'A0B60J', 'BMG1808K1009', null, 'CS', 'HKG', 'BURWILL STK', null, '0024.HK', null, 'HKD', null, 59, 24, null, null, 915752, '1', null, null, 'HKG', null, null, 'BRWILL', 10911800, '6155948', null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 2776, null, 870986, 18496, null, 'Cathay Pacific', '0293.HK', 'Cathay Pacific Airways Ltd', 114764, 591, '870986', 'HK0293001514', null, 'CS', 'HKG', 'CATHAY PACIFIC STK', null, '0293.HK', null, 'HKD', null, 56, 293, null, null, 903694, '1', null, 7030072, 'HKG', null, null, 'CATHP', 5116236, '6179755', null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 5, null, 897920, 12524, null, 'Sun Man Tai', '0433.HK', 'Sun Man Tai Holdings Co Ltd', 103771, 875, 'A0BKKY', 'BMG8582W1192', null, 'CS', 'HKG', 'MKI STK', null, '0206.HK^J95', null, 'HKD', null, 62, null, 'G8582W119', null, 935455, '0', null, null, 'HKG', null, null, 'KOKT', 10958679, null, null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 2776, null, null, 18503, null, 'Chi Cheung', '0112.HK', 'Chi Cheung Investment Co Ltd', 114772, 862, '249819', 'HK0112012916', null, 'CS', 'HKG', 'CHI CHEUNG STK', null, '0112.HK', null, 'HKD', null, 64, 112, null, null, null, '1', null, null, 'HKG', null, null, 'CHICH', null, '6614557', null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 2776, null, null, 40547, null, 'Frankie Dominion', '0704.HK', 'Frankie Dominion International Ltd', 701293, 345, '594725', 'BMG3657Q1050', null, 'CS', 'HKG', 'FRANKIE DOMINION STK', null, '0704.HK', null, 'HKD', null, 41, 704, 'G3657Q105', null, 924062, '1', null, null, 'HKG', null, null, 'DOMFRK', 4582608, '6350129', null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 2776, null, 884434, 18498, null, 'CDW Intl', '0481.HK', 'CDW International Ltd', 1401940, null, '884434', 'KYG1988U1004', null, 'CS', 'HKG', 'CDW INTL STK', null, '0481.HK^D97', null, 'HKD', null, 47, null, 'G1988U100', null, 922118, '0', null, null, 'HKG', null, null, 'HKRES', 4578350, null, null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 2776, null, 877553, 12534, null, 'Century City', '0355.HK', 'Century City International Holdings Ltd', 103792, 536, '877553', 'BMG2020F1014', null, 'CS', 'HKG', 'CENTURY CITY STK', null, '0355.HK', null, 'HKD', null, 64, 355, 'G2020F101', null, 912888, '1', null, null, 'HKG', null, null, 'CCHOL', null, '6185150', null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 5, null, null, 12549, null, 'China Entert', '130.HK', 'China Entertainment and Land Investment Holdings Ltd', 910555, null, null, null, null, 'CS', 'HKG', 'CHINA ENTMT STK', null, 'CELH.HK^I92', null, 'HKD', null, 64, null, null, null, null, '0', null, null, 'HKG', null, null, 'CHELI', null, null, null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 2776, null, 877535, 12551, null, 'Chinese Est H', '0127.HK', 'Chinese Estates Holdings Ltd', 103815, 862, 'A0CANZ', 'BMG2108M1762', null, 'CS', 'HKG', 'CHINESE EST H STK', null, '0127.HK', null, 'HKD', null, 64, 127, null, null, 911677, '1', null, null, 'HKG', null, null, 'CHESTS', 4580346, '6191180', null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 2776, null, 881043, 12482, null, 'Cafe De Coral', '0341.HK', 'Cafe de Coral Holdings Ltd', 103723, 539, '881043', 'BMG1744V1037', null, 'CS', 'HKG', 'CAFE DE CORAL STK', null, '0341.HK', null, 'HKD', null, 53, 341, 'G1744V103', null, 902774, '1', null, null, 'HKG', null, null, 'WELLNT', 4578295, '6160953', null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 5, null, 874483, 12550, null, 'China & Eastrn', null, 'China & Eastern Investment Co Ltd', 114773, null, '874483', 'HK0110000632', null, 'CS', 'HKG', 'CHINA & EASTERN STK', null, '0110.HK^A96', null, 'HKD', null, 62, null, null, null, 903239, '0', null, 7612173, 'HKG', null, null, 'CHNEAS', 4578643, '6190808', null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 2776, null, 885542, 18508, null, 'Grand Field Gp', '0115.HK', 'Grand Field Group Holdings Ltd', 114779, 862, '723772', 'BMG4054H1108', null, 'CS', 'HKG', 'GRAND FIELD GP STK', null, '0115.HK', null, 'HKD', null, 11, 115, 'G4054H110', null, null, '1', null, null, 'HKG', null, null, 'CHINTO', null, '6268512', null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 2776, null, 863343, 18521, null, 'Cross-Har Hold', '0032.HK', 'Cross-Harbour (Holdings) Ltd', 114795, 583, '863343', 'HK0032009356', null, 'CS', 'HKG', 'CROSS HAR HOLD STK', null, '0032.HK', null, 'HKD', null, 52, 32, null, null, 900698, '1', null, 6513245, 'HKG', null, null, 'CHT', null, '6235367', null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 2776, null, 882231, 12557, null, 'Chuang's Intl', '0367.HK', 'Chuang's Consortium International Ltd', 103824, 862, '882231', 'BMG2122V1458', null, 'CS', 'HKG', 'CHUANG'S INTL STK', null, '0367.HK', null, 'HKD', null, 64, 367, 'G2122V145', null, 911190, '1', null, 7145260, 'HKG', null, null, 'CHNG', null, '6197401', null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 2776, null, 877257, 39654, null, 'Chevalier Intl', '0025.HK', 'Chevalier International Holdings Ltd', 254301, 137, '461279', 'BMG2097Z1471', null, 'CS', 'HKG', 'CHEVALIER INTL STK', null, '0025.HK', null, 'HKD', null, 32, 25, null, null, 985214, '1', null, 7281060, 'HKG', null, null, 'CHEVHK', 4595807, '6616984', null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 2776, null, null, 39653, null, 'Chevalier Itech', '0508.HK', 'Chevalier iTech Holdings Ltd', 701135, 253, '553166', 'BMG209831210', null, 'CS', 'HKG', 'CHEVALIER ITECH STK', null, '0508.HK', null, 'HKD', null, 55, 508, null, null, 919875, '1', null, 7488396, 'HKG', null, null, 'CHEVA', 17151533, '6617006', null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 5, null, null, 18511, null, 'Dynamic Hldgs', '0029.HK', 'Dynamic Holdings Ltd', 114783, 862, null, null, null, 'PD', 'HKG', 'DYNAMIC PR', null, 'CHWA_p.HK^C90', null, 'HKD', null, 64, null, null, null, null, '0', null, null, 'HKG', null, null, 'CWSE', null, null, null); INSERT INTO EQUITIES_XREF (RIO_DE_JANEIRO_CODE, NEW_MSCI_INDUSTRL_CLASSN_CODE, PE, VALOREN, AUSTRIA_CODE, ISSUER_ID, TICKER, ORGANISATION_DISPLAY_NAME, PRIMARY_RIC_IDENTIFIER, DIRECTORY_COMPANY_NAME, PRIMARY_ISSUE_LEVEL_CODE, FTSE_INDUSTRIAL_CLASSN_CODE, GERMAN_CODE, ISIN, ISO_CLASSN_FINANCL_INSTR_CODE, ISSUE_CLASSIFICATION, ORGANISATION_GEOGRAPHICAL_UNIT, DESCRIPTION, QUICK, RIC, AUSTRALIA_CODE, CURRENCY_CODE, DOWJONES_STOXX_IND_CLASSN_CODE, INDUSTRIAL_CLASSIFICATION_CODE, MARKET_LEVEL_CDHKG, CUSIP, NETHERLANDS_CODE, SICOVAM, TRADING_STATUS, MARKET_LEVEL_SINGAPORE_CODE, BELGIUM_CODE, EXCHANGE_ID, SAO_PAULO_CODE, TAIWAN_CODE, FINSBURY_COMPANY_CODE, CEDEL_EUROCLEAR, SEDOL, MARKET_LEVEL_MALAYSIAN_CODE) VALUES ( null, null, 2776, null, null, 18511, null, 'Dynamic Hldgs', '0029.HK', 'Dynamic Holdings Ltd', 114782, 862, '789635', 'BMG2889K1678', null, 'CS', 'HKG', 'DYNAMIC HLDGS STK', null, '0029.HK', null, 'HKD', null, 64, 29, 'G2889K167', null, null, '1', null, 7225587, 'HKG', null, null, 'CWSE', null, '6290117', null);
Any way I can have some diagnostics on whar MySQL server is doing with this 2nd Statement execute?
David
Subject
Written By
Posted
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.