I have written to this forum before but have not been able to resolve the connection time being SO long. My MS Access database is currently about 54M. It takes well over 4 minutes to create a connection. There is a slow amount of growth to this database and the connection time has risen with the size.
I have no external links in the database. All the data is contained within the MS Access database. There doesn't seem to be anything wrong with the database itself (but of course it may be hard to tell with MS Access). While not the same, when I connect with MS Excel via ADO, it connects instantly and I would assume if there were something wrong with the database, it would fail at some point (either on connection or query or something).
Can anyone help me trying and figure out why this connection takes so long. I've been using UCanAccess for a while and it certainly does it's job when up and running. But 4 minutes to connect is a hard pill to swallow particularly given the size of the DB.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have written to this forum before but have not been able to resolve the
connection time being SO long. My MS Access database is currently about
54M. It takes well over 4 minutes to create a connection. There is a slow
amount of growth to this database and the connection time has risen with
the size.
I have no external links in the database. All the data is contained within
the MS Access database. There doesn't seem to be anything wrong with the
database itself (but of course it may be hard to tell with MS Access).
While not the same, when I connect with MS Excel via ADO, it connects
instantly and I would assume if there were something wrong with the
database, it would fail at some point (either on connection or query or
something).
Can anyone help me trying and figure out why this connection takes so
long. I've been using UCanAccess for a while and it certainly does it's job
when up and running. But 4 minutes to connect is a hard pill to swallow
particularly given the size of the DB.
The console keeps defaultint to the 64-bit version for some reason. I have both on my machine. I think that's what's causing the console.bat to not work properly.
java version "1.8.0_301"
Java(TM) SE Runtime Environment (build 1.8.0_301-b25)
Java HotSpot(TM) 64-Bit Server VM (build 25.301-b25, mixed mode)
Please, enter the full path to the access file (.mdb or .accdb): H:\Tools\Access Databases\indexhistories.accdb
java.io.IOException: Unrecognized map type: -1
at com.healthmarketscience.jackcess.impl.UsageMap.initHandler(UsageMap.java:150)
at com.healthmarketscience.jackcess.impl.UsageMap.read(UsageMap.java:136)
at com.healthmarketscience.jackcess.impl.PageChannel.initialize(PageChannel.java:117)
at com.healthmarketscience.jackcess.impl.DatabaseImpl.<init>(DatabaseImpl.java:532)
at com.healthmarketscience.jackcess.impl.DatabaseImpl.open(DatabaseImpl.java:401)
at com.healthmarketscience.jackcess.DatabaseBuilder.open(DatabaseBuilder.java:252)
at net.ucanaccess.console.Main.hasPassword(Main.java:73)
at net.ucanaccess.console.Main.main(Main.java:142)
Unrecognized map type: -1
Press any key to continue . . .</init>
From: Marco Amadei [mailto:jamadei@users.sourceforge.net]
Sent: Monday, October 25, 2021 1:21 PM
To: [ucanaccess:discussion]help@discussion.ucanaccess.p.re.sourceforge.net
Subject: [ucanaccess:discussion] Re: Extremely long connection time
If you try to use the console.bat (in the distribution) to open the file
what do you see? Could you send the console output?
Il giorno lun 25 ott 2021 alle ore 13:56 Lon Parisi lonparisi@users.sourceforge.netlonparisi@users.sourceforge.net ha scritto:
Hello,
I have written to this forum before but have not been able to resolve the
connection time being SO long. My MS Access database is currently about
54M. It takes well over 4 minutes to create a connection. There is a slow
amount of growth to this database and the connection time has risen with
the size.
I have no external links in the database. All the data is contained within
the MS Access database. There doesn't seem to be anything wrong with the
database itself (but of course it may be hard to tell with MS Access).
While not the same, when I connect with MS Excel via ADO, it connects
instantly and I would assume if there were something wrong with the
database, it would fail at some point (either on connection or query or
something).
Can anyone help me trying and figure out why this connection takes so
long. I've been using UCanAccess for a while and it certainly does it's job
when up and running. But 4 minutes to connect is a hard pill to swallow
particularly given the size of the DB.
This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary and subject to important terms and conditions available at http://www.bankofamerica.com/emaildisclaimer. If you are not the intended recipient, please delete this message.
Hello,
I was able to force my 32-bit version of java by copying the script and hard-coding the path. Here is what the console outputted:
java version "1.8.0_301"
Java(TM) SE Runtime Environment (build 1.8.0_301-b25)
Java HotSpot(TM) 64-Bit Server VM (build 25.301-b25, mixed mode)
Please, enter the full path to the access file (.mdb or .accdb): H:\Tools\Access Databases\indexhistories.accdb
Error occured at the first loading attempt of GetLiquidUnderlyings
Converted view was :CREATE VIEW GETLIQUIDUNDERLYINGS AS SELECT TICKER || ' EQUITY' AS STRIPPED_TICKER
FROM SEC_PERFORMANCE
WHERE (volume_total_put + volume_total_call) > 500 and (open_int_total_call + open_int_total_put) > 50000
and ticker in (select ticker from portmap where portfolio = xPortfolio)
Error message was :user lacks privilege or object not found: XPORTFOLIO
Loaded Tables:
Beta, Betaold, Buybacks, Chains, CurIndexWeights, DeltaVol, Dislocations, DUAL, EarnHistory, EarnHistPerf, FOMCAnnouncements, FundRatios, ImpliedCorrelation, MarketDates, MergerArbDeals, NextEarnings, OptionLiquidity, PortAgg, PortMap, PutCallSpreads, RegStats, RelValStats, RelValUnderlyings, SEC_PERFORMANCE, SectorETF, SeqTbl, Spreads1x2, TradeIDSeq, TradeTracker, TradeTrackerComb, TradeTrackerPL, TradeTrackerPLStats, VarSwapHist, VIXRolldown, YieldCurves
Loaded Queries:
DownBetaCandidates, GetTightRelValRatios, GetTightRelValSectorRatios, GetTightRelValSpreads, NQtrAvgEarnRet, Query1, StockBuybacks, YTDOutPerformers, YTDUnderPerformers
Loaded Procedures:
Loaded Indexes:
Primary Key on DUAL Columns: (FAKE_FIELD)
, Primary Key on MarketDates Columns: (MARKET_DATE)
, Primary Key on MergerArbDeals Columns: (DEAL_ID)
, Primary Key on OptionLiquidity Columns: (TICKER,MARKET_DATE)
, Primary Key on PortAgg Columns: (AGG_PORT_NAME,PORTFOLIO)
, Primary Key on RegStats Columns: (Ticker,MarketDate)
, Primary Key on RelValUnderlyings Columns: (TICKER)
, Index Unique on SectorETF Columns: (Sector_ETF)
, Primary Key on SectorETF Columns: (Sector_ETF,Sector)
, Index Unique on SectorETF Columns: (Sector)
, Primary Key on SeqTbl Columns: (NextVal)
, Primary Key on TradeIDSeq Columns: (NextSeq)
, Primary Key on TradeTrackerPLStats Columns: (TradeID)
, Index on Beta Columns: (NUM_DATA_POINTS)
, Index on Buybacks Columns: (Ticker)
, Index on DeltaVol Columns: (Market_Date)
, Index on DeltaVol Columns: (Ticker)
, Index on Dislocations Columns: (DATA_TYPE)
, Index on Dislocations Columns: (LOOKBACK_TENOR)
, Index on Dislocations Columns: (MARKET_DATE)
, Index on Dislocations Columns: (DATA_TYPE_NUM_OBS)
, Index on Dislocations Columns: (TICKER)
, Index on EarnHistory Columns: (ANN_DATE)
, Index on EarnHistory Columns: (TICKER)
, Index on EarnHistory Columns: (YEAR_PERIOD)
, Index on EarnHistPerf Columns: (CUR_HIST)
, Index on EarnHistPerf Columns: (EARN_DATE)
, Index on EarnHistPerf Columns: (MARKET_DATE)
, Index on EarnHistPerf Columns: (TICKER)
, Index on ImpliedCorrelation Columns: (CorrelationType)
, Index on ImpliedCorrelation Columns: (MarketDate)
, Index on ImpliedCorrelation Columns: (Tenor)
, Index on ImpliedCorrelation Columns: (Ticker)
, Index on ImpliedCorrelation Columns: (TopN)
, Index on MergerArbDeals Columns: (DEAL_ID)
, Index on NextEarnings Columns: (EXPECTED_REPORT_DT)
, Index on OptionLiquidity Columns: (MARKET_DATE)
, Index on OptionLiquidity Columns: (SECTOR)
, Index on OptionLiquidity Columns: (TICKER)
, Index on PortAgg Columns: (AGG_PORT_NAME)
, Index on PortAgg Columns: (PORTFOLIO)
, Index on PortMap Columns: (CreateTime)
, Index on PortMap Columns: (Portfolio)
, Index on PortMap Columns: (User_ID)
, Index on PutCallSpreads Columns: (EOD_RUN)
, Index on PutCallSpreads Columns: (EXPIRY)
, Index on PutCallSpreads Columns: (IDX_SRC)
, Index on PutCallSpreads Columns: (MARKET_DATE)
, Index on PutCallSpreads Columns: (PC)
, Index on PutCallSpreads Columns: (TARG_MAX_PROF_TO_COST)
, Index on PutCallSpreads Columns: (TICKER)
, Index on SEC_PERFORMANCE Columns: (GICS_SECTOR_NAME)
, Index on SEC_PERFORMANCE Columns: (TICKER)
, Index on TradeTracker Columns: (StartMarketDate)
, Index on TradeTracker Columns: (TradeID)
, Index on TradeTracker Columns: (TradeLegID)
, Index on TradeTracker Columns: (UnderlyingTicker)
, Index on TradeTracker Columns: (UserID)
, Index on TradeTrackerComb Columns: (COMB_TRADEID)
, Index on TradeTrackerComb Columns: (TRADEID)
, Index on TradeTrackerPL Columns: (MARKET_DATE)
, Index on TradeTrackerPL Columns: (TRADEID)
, Index on VarSwapHist Columns: (MARKET_DATE)
, Index on VarSwapHist Columns: (TENOR)
, Index on VarSwapHist Columns: (TICKER)
Cannot load view GetLiquidUnderlyingsPortfolio : user lacks privilege or object not found: XPORTFOLIO
Cannot load view GetLiquidUnderlyings : user lacks privilege or object not found: XPORTFOLIO
Cannot load procedure UpdateSEC_PERFORMANCESectors unexpected token: INNER required: SET
Cannot load procedure UpdateSpreadEarningsDates unexpected token: INNER required: SET
UCanAccess>
Copyright (c) 2021 Marco Amadei
UCanAccess version 4.0.4
You are connected!!
Type quit to exit
Hello,
I have written to this forum before but have not been able to resolve the connection time being SO long. My MS Access database is currently about 54M. It takes well over 4 minutes to create a connection. There is a slow amount of growth to this database and the connection time has risen with the size.
I have no external links in the database. All the data is contained within the MS Access database. There doesn't seem to be anything wrong with the database itself (but of course it may be hard to tell with MS Access). While not the same, when I connect with MS Excel via ADO, it connects instantly and I would assume if there were something wrong with the database, it would fail at some point (either on connection or query or something).
Can anyone help me trying and figure out why this connection takes so long. I've been using UCanAccess for a while and it certainly does it's job when up and running. But 4 minutes to connect is a hard pill to swallow particularly given the size of the DB.
If you try to use the console.bat (in the distribution) to open the file
what do you see? Could you send the console output?
Il giorno lun 25 ott 2021 alle ore 13:56 Lon Parisi lonparisi@users.sourceforge.net ha scritto:
The console keeps defaultint to the 64-bit version for some reason. I have both on my machine. I think that's what's causing the console.bat to not work properly.
java version "1.8.0_301"
Java(TM) SE Runtime Environment (build 1.8.0_301-b25)
Java HotSpot(TM) 64-Bit Server VM (build 25.301-b25, mixed mode)
Please, enter the full path to the access file (.mdb or .accdb): H:\Tools\Access Databases\indexhistories.accdb
java.io.IOException: Unrecognized map type: -1
at com.healthmarketscience.jackcess.impl.UsageMap.initHandler(UsageMap.java:150)
at com.healthmarketscience.jackcess.impl.UsageMap.read(UsageMap.java:136)
at com.healthmarketscience.jackcess.impl.PageChannel.initialize(PageChannel.java:117)
at com.healthmarketscience.jackcess.impl.DatabaseImpl.<init>(DatabaseImpl.java:532)
at com.healthmarketscience.jackcess.impl.DatabaseImpl.open(DatabaseImpl.java:401)
at com.healthmarketscience.jackcess.DatabaseBuilder.open(DatabaseBuilder.java:252)
at net.ucanaccess.console.Main.hasPassword(Main.java:73)
at net.ucanaccess.console.Main.main(Main.java:142)
Unrecognized map type: -1
Press any key to continue . . .</init>
From: Marco Amadei [mailto:jamadei@users.sourceforge.net]
Sent: Monday, October 25, 2021 1:21 PM
To: [ucanaccess:discussion] help@discussion.ucanaccess.p.re.sourceforge.net
Subject: [ucanaccess:discussion] Re: Extremely long connection time
If you try to use the console.bat (in the distribution) to open the file
what do you see? Could you send the console output?
Il giorno lun 25 ott 2021 alle ore 13:56 Lon Parisi lonparisi@users.sourceforge.netlonparisi@users.sourceforge.net ha scritto:
Hello,
I have written to this forum before but have not been able to resolve the
connection time being SO long. My MS Access database is currently about
54M. It takes well over 4 minutes to create a connection. There is a slow
amount of growth to this database and the connection time has risen with
the size.
I have no external links in the database. All the data is contained within
the MS Access database. There doesn't seem to be anything wrong with the
database itself (but of course it may be hard to tell with MS Access).
While not the same, when I connect with MS Excel via ADO, it connects
instantly and I would assume if there were something wrong with the
database, it would fail at some point (either on connection or query or
something).
Can anyone help me trying and figure out why this connection takes so
long. I've been using UCanAccess for a while and it certainly does it's job
when up and running. But 4 minutes to connect is a hard pill to swallow
particularly given the size of the DB.
Extremely long connection time
https://sourceforge.net/p/ucanaccess/discussion/help/thread/2e7e169cf4/?limit=25#ada5https://urldefense.com/v3/__https:/sourceforge.net/p/ucanaccess/discussion/help/thread/2e7e169cf4/?limit=25*ada5__;Iw!!I2XIyG2ANlwasLbx!Ep5Nr6HM_Pb3wT9HN9zkJslLTn02KyRjL8OcT-xY5DQTIKC--QFEyPeJpTw0Zik$
Sent from sourceforge.net because amadei.mar@gmail.comamadei.mar@gmail.com is subscribed to
https://sourceforge.net/p/ucanaccess/discussion/help/https://urldefense.com/v3/__https:/sourceforge.net/p/ucanaccess/discussion/help/__;!!I2XIyG2ANlwasLbx!Ep5Nr6HM_Pb3wT9HN9zkJslLTn02KyRjL8OcT-xY5DQTIKC--QFEyPeJOI0nV4Y$
To unsubscribe from further messages, a project admin can change settings
at https://sourceforge.net/p/ucanaccess/admin/discussion/forums.https://urldefense.com/v3/__https:/sourceforge.net/p/ucanaccess/admin/discussion/forums.__;!!I2XIyG2ANlwasLbx!Ep5Nr6HM_Pb3wT9HN9zkJslLTn02KyRjL8OcT-xY5DQTIKC--QFEyPeJxVCHBPA$ Or, if
this is a mailing list, you can unsubscribe from the mailing list.
Extremely long connection timehttps://urldefense.com/v3/__https:/sourceforge.net/p/ucanaccess/discussion/help/thread/2e7e169cf4/?limit=25*ada5*7a8d__;Iy8!!I2XIyG2ANlwasLbx!Ep5Nr6HM_Pb3wT9HN9zkJslLTn02KyRjL8OcT-xY5DQTIKC--QFEyPeJxUUMPRI$
Sent from sourceforge.net because you indicated interest in https://sourceforge.net/p/ucanaccess/discussion/help/https://urldefense.com/v3/__https:/sourceforge.net/p/ucanaccess/discussion/help/__;!!I2XIyG2ANlwasLbx!Ep5Nr6HM_Pb3wT9HN9zkJslLTn02KyRjL8OcT-xY5DQTIKC--QFEyPeJOI0nV4Y$
To unsubscribe from further messages, please visit https://sourceforge.net/auth/subscriptions/https://urldefense.com/v3/__https:/sourceforge.net/auth/subscriptions/__;!!I2XIyG2ANlwasLbx!Ep5Nr6HM_Pb3wT9HN9zkJslLTn02KyRjL8OcT-xY5DQTIKC--QFEyPeJU2Xhg7U$
This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary and subject to important terms and conditions available at http://www.bankofamerica.com/emaildisclaimer. If you are not the intended recipient, please delete this message.
Hello,
I was able to force my 32-bit version of java by copying the script and hard-coding the path. Here is what the console outputted:
java version "1.8.0_301"
Java(TM) SE Runtime Environment (build 1.8.0_301-b25)
Java HotSpot(TM) 64-Bit Server VM (build 25.301-b25, mixed mode)
Please, enter the full path to the access file (.mdb or .accdb): H:\Tools\Access Databases\indexhistories.accdb
Error occured at the first loading attempt of GetLiquidUnderlyings
Converted view was :CREATE VIEW GETLIQUIDUNDERLYINGS AS SELECT TICKER || ' EQUITY' AS STRIPPED_TICKER
FROM SEC_PERFORMANCE
WHERE (volume_total_put + volume_total_call) > 500 and (open_int_total_call + open_int_total_put) > 50000
and ticker in (select ticker from portmap where portfolio = xPortfolio)
Error message was :user lacks privilege or object not found: XPORTFOLIO
Loaded Tables:
Beta, Betaold, Buybacks, Chains, CurIndexWeights, DeltaVol, Dislocations, DUAL, EarnHistory, EarnHistPerf, FOMCAnnouncements, FundRatios, ImpliedCorrelation, MarketDates, MergerArbDeals, NextEarnings, OptionLiquidity, PortAgg, PortMap, PutCallSpreads, RegStats, RelValStats, RelValUnderlyings, SEC_PERFORMANCE, SectorETF, SeqTbl, Spreads1x2, TradeIDSeq, TradeTracker, TradeTrackerComb, TradeTrackerPL, TradeTrackerPLStats, VarSwapHist, VIXRolldown, YieldCurves
Loaded Queries:
DownBetaCandidates, GetTightRelValRatios, GetTightRelValSectorRatios, GetTightRelValSpreads, NQtrAvgEarnRet, Query1, StockBuybacks, YTDOutPerformers, YTDUnderPerformers
Loaded Procedures:
Loaded Indexes:
Primary Key on DUAL Columns: (FAKE_FIELD)
, Primary Key on MarketDates Columns: (MARKET_DATE)
, Primary Key on MergerArbDeals Columns: (DEAL_ID)
, Primary Key on OptionLiquidity Columns: (TICKER,MARKET_DATE)
, Primary Key on PortAgg Columns: (AGG_PORT_NAME,PORTFOLIO)
, Primary Key on RegStats Columns: (Ticker,MarketDate)
, Primary Key on RelValUnderlyings Columns: (TICKER)
, Index Unique on SectorETF Columns: (Sector_ETF)
, Primary Key on SectorETF Columns: (Sector_ETF,Sector)
, Index Unique on SectorETF Columns: (Sector)
, Primary Key on SeqTbl Columns: (NextVal)
, Primary Key on TradeIDSeq Columns: (NextSeq)
, Primary Key on TradeTrackerPLStats Columns: (TradeID)
, Index on Beta Columns: (NUM_DATA_POINTS)
, Index on Buybacks Columns: (Ticker)
, Index on DeltaVol Columns: (Market_Date)
, Index on DeltaVol Columns: (Ticker)
, Index on Dislocations Columns: (DATA_TYPE)
, Index on Dislocations Columns: (LOOKBACK_TENOR)
, Index on Dislocations Columns: (MARKET_DATE)
, Index on Dislocations Columns: (DATA_TYPE_NUM_OBS)
, Index on Dislocations Columns: (TICKER)
, Index on EarnHistory Columns: (ANN_DATE)
, Index on EarnHistory Columns: (TICKER)
, Index on EarnHistory Columns: (YEAR_PERIOD)
, Index on EarnHistPerf Columns: (CUR_HIST)
, Index on EarnHistPerf Columns: (EARN_DATE)
, Index on EarnHistPerf Columns: (MARKET_DATE)
, Index on EarnHistPerf Columns: (TICKER)
, Index on ImpliedCorrelation Columns: (CorrelationType)
, Index on ImpliedCorrelation Columns: (MarketDate)
, Index on ImpliedCorrelation Columns: (Tenor)
, Index on ImpliedCorrelation Columns: (Ticker)
, Index on ImpliedCorrelation Columns: (TopN)
, Index on MergerArbDeals Columns: (DEAL_ID)
, Index on NextEarnings Columns: (EXPECTED_REPORT_DT)
, Index on OptionLiquidity Columns: (MARKET_DATE)
, Index on OptionLiquidity Columns: (SECTOR)
, Index on OptionLiquidity Columns: (TICKER)
, Index on PortAgg Columns: (AGG_PORT_NAME)
, Index on PortAgg Columns: (PORTFOLIO)
, Index on PortMap Columns: (CreateTime)
, Index on PortMap Columns: (Portfolio)
, Index on PortMap Columns: (User_ID)
, Index on PutCallSpreads Columns: (EOD_RUN)
, Index on PutCallSpreads Columns: (EXPIRY)
, Index on PutCallSpreads Columns: (IDX_SRC)
, Index on PutCallSpreads Columns: (MARKET_DATE)
, Index on PutCallSpreads Columns: (PC)
, Index on PutCallSpreads Columns: (TARG_MAX_PROF_TO_COST)
, Index on PutCallSpreads Columns: (TICKER)
, Index on SEC_PERFORMANCE Columns: (GICS_SECTOR_NAME)
, Index on SEC_PERFORMANCE Columns: (TICKER)
, Index on TradeTracker Columns: (StartMarketDate)
, Index on TradeTracker Columns: (TradeID)
, Index on TradeTracker Columns: (TradeLegID)
, Index on TradeTracker Columns: (UnderlyingTicker)
, Index on TradeTracker Columns: (UserID)
, Index on TradeTrackerComb Columns: (COMB_TRADEID)
, Index on TradeTrackerComb Columns: (TRADEID)
, Index on TradeTrackerPL Columns: (MARKET_DATE)
, Index on TradeTrackerPL Columns: (TRADEID)
, Index on VarSwapHist Columns: (MARKET_DATE)
, Index on VarSwapHist Columns: (TENOR)
, Index on VarSwapHist Columns: (TICKER)
Cannot load view GetLiquidUnderlyingsPortfolio : user lacks privilege or object not found: XPORTFOLIO
Cannot load view GetLiquidUnderlyings : user lacks privilege or object not found: XPORTFOLIO
Cannot load procedure UpdateSEC_PERFORMANCESectors unexpected token: INNER required: SET
Cannot load procedure UpdateSpreadEarningsDates unexpected token: INNER required: SET
UCanAccess>
Copyright (c) 2021 Marco Amadei
UCanAccess version 4.0.4
You are connected!!
Type quit to exit
Commands end with ;
Use:
]export [--help] [--bom] [-d <delimiter>]</delimiter> [-t