Re: Does partitioning make sense for this application?

[Paul Schmehl]

>
> Look at these two _strings_:
> '10.21.21.0'
> '10.21.3.0'
> Which one will sort _first_? The first on, which
> has a "2" paired up with the "3" in the second
> one. That implies that
> WHERE srcip BETWEEN '10.21.21.0' AND '10.21.44.0'
> will _include_ '10.21.3.0', which is not what is
> meant by IP ranges.
>

I screwed that up. If you look at the actual queries I was searching 10.21.21.0 to 10.21.30.255.

>
> Question: Are the typical queries for "recent"
> timeranges? If so, we can discuss partitioning on
> stime; it will help _some_ queries. (Well, cannot
> use stime as it stands, but we can work on that.)
>

Yes, they are for recent timeframes - usually within the past 24 hours, although occasionally we get asked to look back in time a ways.


> How many rows will you be inserting per second?

1200 to 1500

> Do you have RAID striping?

No, but we're in the early planning stages, so it's certainly a possibility.