20K photos

--0-1664797140-1177874552=:54433
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Hi all,
Imagine that you want to put some 20000 historical photos On display in your website , you use PHP and MySQL.
Preparing a photo album with 200 photos is no problem but for 20000 photos! would you do it in the same way?

Please comment.


---------------------------------
Ahhh...imagining that irresistible "new car" smell?
Check outnew cars at Yahoo! Autos.
--0-1664797140-1177874552=:54433--

Re: 20K photos

Sorry but I don't see where the problem would be.

Aleksander

Quoting elk dolk :

> Hi all,
> Imagine that you want to put some 20000 historical photos On
> display in your website , you use PHP and MySQL.
> Preparing a photo album with 200 photos is no problem but for
> 20000 photos! would you do it in the same way?
>
> Please comment.
>
>
> ---------------------------------
> Ahhh...imagining that irresistible "new car" smell?
> Check outnew cars at Yahoo! Autos.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: 20K photos

Hi

> Imagine that you want to put some 20000 historical photos On display in your website , you use PHP and MySQL.
> Preparing a photo album with 200 photos is no problem but for 20000 photos! would you do it in the same way?

Yes, but I don't necessarily see the need for a db.

If you have additional information on the pictures to store, then yes,
use a db. Otherwise all the info you need is available from the files.

For small numbers I wouldn't store the filenames in the db. For 20K, I
would.

Decide on how many images per page, then use SELECT with LIMIT to pull
out a page's worth of files and show the page. Back/Next tell the page
what offset to use for the LIMIT clause.


Niel

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: 20K photos

--H1spWtNR+x+ondvy
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Am 2007-04-29 12:22:32, schrieb elk dolk:
> Hi all,
> Imagine that you want to put some 20000 historical photos On display=
in your website , you use PHP and MySQL.
> Preparing a photo album with 200 photos is no problem but for 20000 pho=
tos! would you do it in the same way?=20
> =20
> Please comment.
------------------------- END OF REPLIED MESSAGE -------------------------

Where is the Problem?

I have a PostgreSQL Database of 680 GByte on a Raid-5 (1,8 TByte)
plus 130 million files on a extra partition of 7.2 TByte (Raid-5).
I link it directly from the PostgreSQL over php into the FS.

Greetings
Michelle Konzack
Systemadministrator
Tamay Dogan Network
Debian GNU/Linux Consultant


--=20
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack Apt. 917 ICQ #328449886
50, rue de Soultz MSN LinuxMichi
0033/6/61925193 67100 Strasbourg/France IRC #Debian (irc.icq.com)

--H1spWtNR+x+ondvy
Content-Type: application/pgp-signature; name="signature.pgp"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFGO0yjC0FPBMSS+BIRAhKtAJ96mXjJ9Ps3JI4Xz066RsQKkeP03ACf WW3p
zcbhXEZanRnnoWSfBZ2w5xY=
=oI17
-----END PGP SIGNATURE-----

--H1spWtNR+x+ondvy--