Hello there,
unless I am missing something, it looks like with FrontBase, EOF/Wonder alas
limits fetches application-side, e.g., my code
===
def fs=...
fs.fetchLimit=1
ec.objectsWithFetchSpecification(fs)
===
with SQL logging switched on yields a result of
===
14:00:57.072 DEBUG === Begin Internal Transaction
14:00:57.073 DEBUG evaluateExpression:
<com.webobjects.jdbcadaptor.FrontbasePlugIn$FrontbaseExpression: "SELECT
t0."C_EDITED_AUCTION_ID", t0."C_CREATION_DATE", t0."C_CREATOR_ID",
t0."C_IP_ADDRESS", t0."C_KIND", t0."C_MARKET_ID", t0."C_TITLE", t0."C_UID",
t0."C_EDITED_USER_ID" FROM "T_AUDIT" t0 ORDER BY t0."C_CREATION_DATE" ASC"
withBindings: >
14:00:57.592 DEBUG fetch canceled
14:00:57.592 DEBUG 1 row(s) processed
14:00:57.600 DEBUG === Commit Internal Transaction
===
FrontBase, nevertheless, does support fetch limits with the TOP syntax, e.g.,
this SQL would work database-level:
===
SELECT TOP(1) t0."C_EDITED_AUCTION_ID", t0."C_CREATION_DATE",
t0."C_CREATOR_ID", t0."C_IP_ADDRESS", t0."C_KIND", t0."C_MARKET_ID",
t0."C_TITLE", t0."C_UID", t0."C_EDITED_USER_ID" FROM "T_AUDIT" t0 ORDER BY
t0."C_CREATION_DATE" ASC
===
Is there anything I could do to fix that my applicatio(s) really use this and
don't try to fetch the complete table?
Thanks,
OC
_______________________________________________
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]
