Repository navigation
Interpretation of of FbDatabaseInfo values for BlackbirdSql SqlEditor port. #1157
Description
Activity
1 & 2> Yeah. Looks like these methods are returning complete garbage. I guess, I'm parsing the response back incorrectly. I'll check and fix it.
3> I don't know from top of my head. But you can maybe check theisc_info_xxxorfb_info_xxxin Firebird sources whether something looks "suspicious". And if so, let me know and I'll add it.Thanks Jiri,
I have had a look through the isc codes but there's nothing that would return a server execution time. There was something elsewhere that returned a long that implied user server stats, and that I spent some time trying to decipher. Now I can't find it. I'll get back to you when I do.
Microsoft SqlServer does include "request cost" in it's SqlEditor stats. I see there is an isc code "isc_info_request_cost". It would be great if you could include that when you have some time.
Regards, Greg
Okay so the majority of the isc codes return a struct with an array of value pairs. I am using Reflection atm to access the
Version10.GdsDatabase::DatabaseInfo()method to get to the response buffer.
The structure of the buffer is as follows:Byte 0 contains the isc code.
Bytes 1 and 2 contain the 16 bit UInt16 byte size of the value pairs array.
Following that is the value pairs array.
Each value pair consists of a 6 byte block as follows:
The first 2 bytes are the 16 bit UInt16 ID of the affected/applicable table.
The next 4 bytes are the 32 bit UInt32 value pertaining to the table for the isc code.This means that the total number of value pairs is the byte size of the array / 6.
If you could expose the DatabaseInfo() method in FbDatabaseInfo with a public access modifier that would be helpful.
Cheers, Greg
Instead of exposing
GetDatabaseInfo(I assume you're really talking about this one) it makes more sense to me to have an implementation of that call and parsing/processing inFbDatabaseInfo. Feel free to create PR with the implementation.Yeah yeah that's what I meant.
- added a commit that references this issue
on Jun 28, 2024
Hi,
This is not an issue but not sure where else to ask this. Hope you can help.
I have been struggling to make sense of some of the values returned from FbDatabaseInfo which I am using in the BlackbirdSql DDEX extension's SqlEditor port.
Server Execution Timeof a query?The extension is already released but I would like to jack up the stats reporting so that they're more useful.
Appreciate if you could help me out here. Thanks.
Greg