Re: obtain a BLOB size without fetching the whole thing?
Re: obtain a BLOB size without fetching the whole thing?
- Subject: Re: obtain a BLOB size without fetching the whole thing?
- From: ocs--- via Webobjects-dev <email@hidden>
- Date: Tue, 24 Jun 2025 23:33:08 +0200
Great, thanks! Works like a charm :)
If there is a trick to do this at a higher EOF level, would be nice, but if
there's none, this solves my problem all right. Thanks again!
All the best,
OC
> On 24. 6. 2025, at 23:25, Amedeo Mantica <email@hidden> wrote:
>
> try something like this...
> (raw SQL)
>
> SELECT id, OCTET_LENGTH(blob_col) AS blob_size_bytes FROM my_table;
>
>> Il giorno 24 giu 2025, alle ore 21:27, ocs--- via Webobjects-dev
>> <email@hidden> ha scritto:
>>
>> Hi there,
>>
>> the subject says it all. I've got a FS which reads in some columns set up
>> through setRawRowKeyPaths. The entity contains also a BLOB column which can
>> be rather big. Is there a trick to get its size only in the result
>> dictionaries, without actually fetching the data?
>>
>> If db-specific, with FrontBase.
>>
>> Thanks a lot!
>> OC
>> _______________________________________________
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list (email@hidden)
>> Help/Unsubscribe/Update your Subscription:
>>
>> This email sent to email@hidden
>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden