By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,731 Members | 1,104 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,731 IT Pros & Developers. It's quick & easy.

Total size of serialized data

P: n/a
hi
I need to calculate the size of serialized data in db for my quota
operation.How can I find it ?

May 27 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

gezerpunta wrote:
I need to calculate the size of serialized data in db for my quota
operation.How can I find it ?
Assuming "size" = "disk space" and "serialized data" = "output of
serialize()" function and you already have serialized that data, use
LENGTH()
<http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_length>

- --
Edward Z. Yang GnuPG: 0x869C48DA
HTML Purifier <htmlpurifier.org Anti-XSS HTML Filter
[[ 3FA8 E9A9 7385 B691 A6FC B3CB A933 BE7D 869C 48DA ]]
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGWdi2qTO+fYacSNoRArRUAJ9cZ3qTOrA8Zd9ZNyMkcC cMjva9UQCghVV6
LkWGhg8OQas6SclKKgbdwLs=
=iGau
-----END PGP SIGNATURE-----
May 27 '07 #2

P: n/a
my datas are binary files so I uses large object in postgresql.
On 27 Mayıs, 22:15, "Edward Z. Yang" <edwardzy...@thewritingpot.com>
wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

gezerpunta wrote:
I need to calculate the size of serialized data in db for my quota
operation.How can I find it ?

Assuming "size" = "disk space" and "serialized data" = "output of
serialize()" function and you already have serialized that data, use
LENGTH()
<http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function...>

- --
Edward Z. Yang GnuPG: 0x869C48DA
HTML Purifier <htmlpurifier.org Anti-XSS HTML Filter
[[ 3FA8 E9A9 7385 B691 A6FC B3CB A933 BE7D 869C 48DA ]]
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla -http://enigmail.mozdev.org

iD8DBQFGWdi2qTO+fYacSNoRArRUAJ9cZ3qTOrA8Zd9ZNyMkcC cMjva9UQCghVV6
LkWGhg8OQas6SclKKgbdwLs=
=iGau
-----END PGP SIGNATURE-----

May 27 '07 #3

P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

gezerpunta wrote:
my datas are binary files so I uses large object in postgresql.
octet_length()
<http://www.postgresql.org/docs/8.2/interactive/functions-binarystring.html>

Seriously, please RTFM.
- --
Edward Z. Yang GnuPG: 0x869C48DA
HTML Purifier <htmlpurifier.org Anti-XSS HTML Filter
[[ 3FA8 E9A9 7385 B691 A6FC B3CB A933 BE7D 869C 48DA ]]
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGWeUmqTO+fYacSNoRAin7AJ4qrnxXJteAt3ikNp3iz1 HXT4amZACfa4o7
5ENIt1T098k7hEK2/hxv41s=
=k3Ep
-----END PGP SIGNATURE-----
May 27 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.