| Subject | RE: [IBO] SchemaCahe and Procedure Parameters |
|---|---|
| Author | Jason Wharton |
| Post date | 2018-02-20T00:45:41Z |
Dany,
I don't cache the procedure params info in a static file like
I do other schema cache information. I use a live query to grab that info
from the server on an as-needed basis.
I don't exactly remember why I went with that as a design-decision, but that's what is going on right now.
Is this causing
you some trouble somehow?
Jason
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Thursday, September 21, 2017 4:07 AM
To: IBObjects@yahoogroups.com
Subject: [IBO] SchemaCahe and Procedure Parameters
Jason,
I see many statements like this:
SELECT RDB$PARAMETER_NAME
FROM RDB$PROCEDURE_PARAMETERS
WHERE RDB$PARAMETER_TYPE = ?/* RDB$PARAMETER_TYPE */
AND RDB$PROCEDURE_NAME = ?/* RDB$PROCEDURE_NAME */
ORDER BY RDB$PARAMETER_NUMBER ASC
in my monitoring tables.
I have cleared out the SchemaCache directory and restarted my IBO-based
services.
I have (after running a lot of queries) the following files in my
SchemaCache direcory:
BlobInfo, CharacterSetInfo, CaracterSetList, ClientSchemaVer,
ProcedureNames, TableNames.
The services have most stuff in the DFMs. IB_StoreProc is used but i cannot
guarantee that procerures are not called using IB_DSQL or event TIBO-components
(have been rooting the out lately).
I usually check newly added components by clicking on the published Params
property. Usually i click cancel in the dialog, but sometimes maybe i
accidentally hit the OK button. I have many DMs, but the ones i check now have
AutoDefineParams = false.
IMHO it is odd that the file ProcedureParams is not created, the record is
present in IBO$SCHEMA_VERSION.
More info; IBO 5.9.5 (2667)
Could you please check whats going on?
TIA,
/Dany