Just keep a separate database that tracks the most recent upload per user. Whenever bobby uploads a file, its filename replaces whatever filename was in bobby's database row previously. And whenever someone accesses bobby's page, the database is checked to see which file was most recently uploaded by bobby.

It's not a good solution to sort a list only to obtain the single newest. It's a better solution to either keep track of which one is newest, or do a linear search for the newest. In this particular case, I think you're just better off keeping track from the outset so you never have to search through 500,000 files.

For simple database solutions, you could have a look at DBD::SQLite, and of course, DBI. Or perhaps your web server provider already has some other database installed that they'll let you use too.


Dave

In reply to Re: efficient way to find most recently modified files? by davido
in thread efficient way to find most recently modified files? by Anonymous Monk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.