I'm looking for suggestions on a database for large sets of spatial master data. The data itself is not relational, but could be formulated as such. The data as-is is structed as:
latitude, longitude, time-series ("array" of ints)
Currently, we are using MySQL which is not performing well with our large table setup. Indexing the spatial point on our largest table (420 million rows, 500GB in size) took a week before giving up. We are currently also facing frequent server crashes (working on why still).
Because of these problems, I'm looking for suggestions on other databases. Oracle would be an option, but I wonder if we'd just trade complex problem for complex problem. Anyone know of good spatial data experiences with other databases?