PDA

View Full Version : Importing in Non-sequential Order



Ajax
01-04-2011, 03:16 PM
I had to get a new hard drive a while ago, and at that time I imported only some of the hands from my archive files into my new database. I would now like to go back and import the older archive hands into my database as well.

Is it okay for me to import hands into my database that are older than the current hands in my database? If I import older hands, will all of the stats in the reports and the HUD still be accurate, or will they get messed up because the hands were imported in the wrong order?

Patvs
01-04-2011, 08:44 PM
It doesn't matter.
It won't screw up anything.

But it poses an interesting question: whether or not the hands are sorted alphabetically, by hand number, or by import date, in the database... and if you reimport them in a weird order
-1 if that will result in longer query times
-2 if vacuum/analyse will put them in the fastest order

I think if you vacuum/analyse the database, it will re-arrange the order in the database which is the most efficient.