Photo Captions?

[Admin]

I want to add captions to a little photogallery script I have set up (example here: http://www.hungbrand.com/photos/asr_party/).

I was wondering if it was more effecient to put the captions into a plain text file and then parse them out of that (similiar to what Gallery does) or to store them in MySQL?

Does anyone have any experience with this? Any advise on doing it?

Thanks.
Admin.

[sde]

do 100 of them each way and setup micro time to see which is faster ?

[Admin]

Argh, I was hoping for something more than that... freakin mike...

snowboarding Feb. 17th.

[bdl]

Although I agree with Mike's comment about trying it both ways and testing to see which way is faster, I would think it would be faster to simply parse a text file; eliminates having to connect to the MySQL server, run the query, retrieve and sort out the results. Of course then again, what I don't know could fill the Astrodome...heh.

[sde]

what i know could fill 999,999 millionths of 99% of anything ... errrr something like that .. heh

[Epsilon]

With a function as small as this I doubt it would matter much if you use MySQL or a flat text file. As mentioned, you could measure the difference with microtime, but I can't imagine the difference would be noticable to any visitors.

If you already have a MySQL DB for some functions on this site, adding a new table to it is easy and probably worthwhile. If not, I would just use the text file. If you put all the captions on a new line you can easily load each one into an array using the handy file() function.