Ask Your Question

What is the photo size of the database

asked 2015-06-15 14:19:56 -0500

john gravatar image

updated 2015-06-16 10:40:19 -0500

mdean gravatar image

location=0 means agents with a website store all the photos on the agents server and we do not hot link, correct? With our MLS allowing 24 photos per listing, what is the byte size of all the photo's?

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2015-06-16 09:22:04 -0500

mdean gravatar image

location=0 means that the actual photos will be transmitted to the client in the RETS response. location=1 means the URL to the photo will be transmitted instead.

To calculate the absolute maximum size you could need, you'll need to use the following formula:

[# Listings] * [# Pics Per Listing] * [128KB]

Substituting, with 1500 listings as an example:

1500 * 24 * 131072 = 4718592000 bytes

And reducing that to MB: 4500MB (or 4.39GB)

You can also query the Property resource in RETS to get the actual photo count per listing. This information is stored in the L_PictureCount field. The total size is not stored, however, but similar to the above, you can do a SUM(L_PictureCount) from your downloaded data and use the following calculation:

[SUM(L_PictureCount)] * [128KB]

or, assuming we had about 12 photos per listing and not the maximum of 24:

18000 * 131072 = 2359296000 bytes (or 2250MB or 2.2GB)

This calculation will get you closer to the space you would need. As always, you would also want to add a percentage for padding the available space so you don't run out.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools


Asked: 2015-06-15 14:19:56 -0500

Seen: 118 times

Last updated: Jun 16 '15