I'm a bit amazed by this answer. It seems like you think that MySQL is a magic wand of some kind. The OP is quite unclear what kind of queries he wants to perform - and until he clears that up, I don't see how a relational database is going to help you here.

Let's adress your reasoning.

Databases have lots of functions you can use without having to code your own custom data structures. This saves lots of time.
Actually, relational databases have lots of functions that deal with tabular data. Polygons are not not tabular data - it's geometrical data.
Most databases are optimized in ways you could never do in your life time even if you wrote your program in straight assembler. The reason for this is there are a lot of very smart people who spend their time figuring out how to make things quicker and working on databases. For instance, I couldn't code MySQL if I had an entire lifetime.
Most databases are optimized, yes. But they are optimized to deal with transactions, and to perform queries in a relational structure. Things that don't have much to do with geometrical data.
Databases are very quick. I have a database with a hundred thousand records and I can get very specialized SELECTs done in a few hundreths of a second.
Actually, database aren't quick. Databases spend a lot of resources in being consistent, robust and atomic. They can find records reasonable quickly if they can make use of simple indices. I don't see what kind of indices you can use.
Databases cache information for you. So if you perform the same calculation twice you don't need to worry about it.
Yes, but it's not at all clear whether the OP's problem makes this relevant.

Perhaps I'm seeing this all wrong, and you have a brilliant set of tables, indices are relations in mind. In that case, I'd like to see the schema.

Abigail

In reply to Re: cpan Data structure by Abigail-II
in thread cpan Data structure by michaelg

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.