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: Amedeo Mantica via Webobjects-dev <email@hidden>
- Date: Tue, 24 Jun 2025 23:25:07 +0200
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