Re: huge price database question..

On 20 March 2012 22:21, David Kerr <dmk@mr-paradox.net> wrote:

> I'm imagining that you're loading the raw file into a temporary table that
> you're going to use to
> process / slice new data data into your 7000+ actual tables per stock.

Thanks! would "slice new data data into your 7000+ actual tables per
stock." be a relatively quick operation?

>
> So that table doesn't probably need to be around once you've processed your
> stocks through
> that table. so you could just truncate/drop it after you're done.
>
> When you create it, if you avoid indexes the inserts will be faster (it
> doesn't have to rebuild the index every
> insert) so then once the table is loaded, you create the indexes (So it's
> actually useful) and then process the
> data into the various stock tables.
>
> Dave
>
>
>