##Tables + Views

last few hours i've been working on researching and creating temporary tables.

these will be generated when a user requests a map. they will contain all the point information in xml.

Shawn will then read through this, and display accordingly.

We decided this was the best method of preparing data - as making the webserver an equivalent thick client - was a excessive in terms of performance and delay of generating the initial map.

so far i've looked at temp tables in sql server.

i have installed mysql, and have commenced re-creating some of the stored procedures.

if all goes well - then both databases should be quite interchangeable.

i haven't gone for oracle due to it's many quirks in administration out of the box. So for now - i'll stick to the mysql and mssql combo.