Is it possible you are getting cached results on your FrontBaseManager select? If you run the select multiple times in EOF, is it always slow, or just the first time? If it’s always slow, then I’d do the same fetch 1000 times in a loop and let jvisualvm tell me where to find the bottleneck.
On Mar 9, 2015, at 6:05 AM, OC <[email protected]> wrote: > Hello there, > > using "ERXAdaptorChannelDelegate.sqlLogging", I am getting pretty often slow > selects. The select is shown below, but it does not seem to me the database > would be the culprit -- I have tried the very same SELECT repeatedly directly > in the FrontBaseManager, and I am getting consistently fetch times around > 0.005-0.006 s. > > Nevertheless, at the ERXAdaptorChannelDelegate level, I am getting more than > 0.1 s, up to a terrible half second! > > What might be the culprit, and how to cure that? Well there's a lot of > columns, but still, _half a second_? And none of them contains lots of data; > most of the columns are NULLs; the strings are all under 100 characters; > there are three BLOBs -- 141 B, 1 KB and 2.7 KB: all in all, perhaps 5 KB for > the complete row. At that, I could stomach 0.1 s perhaps, but hardly 0.431. > > It is the FrontBase server (5.2.1g 64-bit), if it is relevant information, > running in Mac OS X 10.6.8 10K549, Java 1.6.0_65. > > Does it make any sense? And, more importantly, can I help it in my code > somehow that such abominations do not happen anymore? > > Thanks a lot, > OC > > === > 11:29:16.320 INFO "DBAuction"@2111204009 expression took 431 ms: SELECT > t0."C_COMM_ALLOW_DEMAND_MIN", t0."C_COMM_ALLOW_OFFER_MIN", > t0."C_ALLOWS_PRIVATE_LIMITS", t0."C_AMOUNT_DECIMAL_PLACES", > t0."C_AMOUNT_UNIT", t0."C_ARCHIVATION_DATE", t0."C_ARCHIVED_CONTENTS", > t0."DC_ATTACH_1000002", t0."C_AUCTION_BLOCKED", t0."C_AUCTION_IS_AUTHORIZED", > t0."C_AUCTION_IS_CREATED", t0."C_AUCTION_IS_PUBLISHED", > t0."C_AUCTION_IS_SENT", t0."C_AUCTION_SEQ", > t0."C_AUCTION_START_DELAY_MINUTES", t0."C_AUCTION_TYPE", > t0."C_AUTOMATIC_FIRST_STEP_DELAY", t0."C_AUTOMATIC_NEXT_STEP_DELAY", > t0."C_AUTOMATIC_OFFER_DELAY", t0."C_AUTOMATIC_PRICE_STEP", t0."C_CANCELLED", > t0."DC_CENTRALIZOVANA_1000009", t0."DC_CETNOST_ZALOH_1000009", > t0."DC_CHARAKTER_ODBERU_1000015", t0."DC_CISLOTEST_1000002", > t0."DC_COMMODITY_1000006", t0."C_COMM_PRICE_SELECTION", > t0."C_COMM_TIMECHUNK_STRING", t0."C_CREATION_DATE", t0."C_CREATOR_ID", > t0."C_CURRENT_PRICE", t0."DC_DALSI_OPRAVNENI_1000009", > t0."DC_DALSI_POVINNOSTI_1000009", t0."DC_DATUMTEST_1000002", > t0."C_DECIMAL_PLACES", t0."DC_DODACI_1000037", > t0."DC_DODAVKY_CTVRTLETI_1000015", t0."DC_DREVINA_1000037", > t0."DC_DVOULETONT_1000026", t0."DC_DVOULETOVT_1000026", > t0."DC_DVOUNT_1000026", t0."DC_DVOUPLATNOSTNT_1000026", > t0."DC_DVOUPLATNOSTVT_1000026", t0."DC_DVOUVT_1000026", > t0."DC_DVOUZIMANT_1000026", t0."DC_DVOUZIMAVT_1000026", > t0."C_DF_CONTENT_DATA", t0."DC_EMAILTEST_1000002", t0."C_END_SHIFTED_FROM", > t0."C_END_SHIFTED_TO", t0."DC_FORMA_1000009", t0."DC_FORMA_DOKLADU_1000009", > t0."DC_FORMA_ZALOH_FAKTUR_1000009", t0."DC_HLMLLINK_1000002", > t0."C_INDIVIDUAL_PRICE", t0."DC_JAKOSTKVALITA_1000037", > t0."DC_JAKOSTNITRIDA_1000037", t0."DC_JEDN_CENY_1000009", > t0."DC_JEDNOLETO_1000026", t0."DC_JEDNOTLIVA_1000009", > t0."DC_JEDNOZIMA_1000026", t0."DC_KAPACITNI_1000015", > t0."DC_KAPACITNI2_1000015", t0."C_LAST_VALID_PO_ID", t0."DC_LETO_1000026", > t0."DC_LETONT_1000026", t0."DC_LETOST_1000026", t0."DC_LETOVK_1000026", > t0."DC_LETOVT_1000026", t0."DC_LISTING_1000009", t0."DC_MALOVELKO_1000015", > t0."C_MARKET_ID", t0."C_MAX_AUCTION_DURATION_MINUTES", t0."C_MAX_PRICE", > t0."C_MAX_PRICE_DIFF", t0."C_MIN_AMOUNT_OFFER", t0."C_MIN_PRICE", > t0."C_MIN_PRICE_DIFF", t0."DC_MISTO_1000037", t0."C_MORE_OFFERS_ALLOWED", > t0."DC_NADMEREK_1000037", t0."DC_NAPOJENI_PL_1000015", > t0."C_NEXT_PRICE_STEP_DATE", t0."DC_ODBERNA_MISTA_1000009", > t0."C_OFFER_CAN_EQUAL_ORIGINAL", t0."C_OFFER_STEP", t0."C_ORIGINAL_AMOUNT", > t0."C_ORIGINAL_PRICE", t0."DC_OSTATNI_1000037", > t0."DC_OSTATNI_PODMINKY_1000009", t0."DC_OSTATNIPODMINKY_1000007", > t0."C_OWNER_END_FACTOR", t0."DC_PLATEBNI1_1000037", > t0."DC_PLATEBNI2_1000037", t0."DC_PLATEBNI3_1000037", > t0."DC_PLATEBNIPODMINKY_1000007", t0."DC_PODEPISUJE_1000009", > t0."DC_PODEPISUJEV_1000009", t0."DC_POPIS_1000037", > t0."DC_POPISKOMODITY_1000007", t0."C_PRESENTATION_TIMEOUT_MINUTES", > t0."C_PRESUMED_AUCTION_DURATION_MINUTES", t0."C_PREV_PRICE_STEP_DATE", > t0."C_PRICE_UNIT", t0."DC_PRILOHA_1000009", t0."DC_PRILOHA2_1000009", > t0."C_PT_ID", t0."C_RECORD_FORM_VIEW_IDENTIFIER", > t0."C_RECORD_FORM_PROTOTYPE_ID", t0."DC_REDUKCNI_1000037", > t0."DC_ROK1_1000009", t0."DC_ROKNT_1000026", t0."DC_ROKST_1000026", > t0."DC_ROKVK_1000026", t0."DC_ROKVT_1000026", t0."DC_ROZMERY_1000037", > t0."DC_SAMOODECET_1000009", t0."DC_SAMOODECET3112_1000009", > t0."DC_SAMOODECETDATUM_1000009", t0."DC_SANKCE_1000015", > t0."DC_SANKCE2_1000015", t0."C_AUCTION_END_DATE", > t0."C_QUEUED_AUCTION_DID_START_DATE", t0."C_PRESENTATION_END_DATE", > t0."DC_SJEDNAVANI_DIAGRAMU_1000009", t0."DC_SKUTECNOSTI_1000037", > t0."DC_SML_KONTAKT_AUKCE_1000009", t0."DC_SOUPIS_PRILOH_1000009", > t0."DC_SPLATNEKDNI_1000009", t0."DC_SPLATNOST_1000009", > t0."DC_SUBORG_1000009", t0."DC_SUJ_1000037", t0."DC_SWITCHTEST_1000002", > t0."DC_TABLE_1000002", t0."DC_TABULKA_1000037", > t0."DC_TABULKA_TARIFU_NN_1000009", t0."DC_TABULKATEXT_1000037", > t0."DC_TERMIN_1000037", t0."DC_TERMIN_DO_1000009", t0."DC_TERMIN_OD_1000009", > t0."C_TIME_SHIFT_INTERVAL", t0."C_TIME_CHUNK_UID", t0."C_TITLE", > t0."DC_TLOUSTKOVYSTUPEN_1000037", t0."DC_TLOUSTKY_1000037", > t0."DC_TOLERANCE_1000015", t0."DC_TOLERANCE2_1000015", > t0."DC_TRIPLATNOSTNT_1000026", t0."DC_TRIPLATNOSTST_1000026", > t0."DC_TRIPLATNOSTVK_1000026", t0."DC_TRIPLATNOSTVT_1000026", > t0."DC_TYP_MERENI_1000015", t0."DC_TYPEOFWOODDRUHDREVA_1000002", t0."C_UID", > t0."C_UNDERBELLY_RS_IDENTIFIER", t0."C_UNITED_RS_IDENTIFIER", > t0."DC_URLOBRAZEK_1000002", t0."DC_URLTEST_1000002", > t0."DC_VN_PO_MESICICH_1000009", t0."DC_WOODTYPE_1000002", > t0."DC_YOUTUBEVIDEO_1000002", t0."DC_ZIMA_1000026", t0."DC_ZIMANT_1000026", > t0."DC_ZIMAST_1000026", t0."DC_ZIMAVK_1000026", t0."DC_ZIMAVT_1000026", > t0."DC_ZPRAVA_1000009", t0."DC_ZUCTOVACI_1000009" FROM "T_AUCTION" t0 WHERE > t0."C_UID" = 1000762 > //log:er.extensions.ERXAdaptorChannelDelegate.sqlLogging [WorkerThread13] > === > > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list ([email protected]) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/rgurley%40smarthealth.com > > This email sent to [email protected] _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
