Performance improvement for xml loads (+comments)

Patrick Spinler spinler.patrick@mayo.edu
Fri, 08 Dec 2000 15:29:52 -0600


Derek Atkins wrote:
> 
> > > Not everything in the GnuCash data is an SQL primitive data type.
> >
> > I'm having a hard time thinking of anything.  I was planning that we
> > go out of the way to make sure we use primitives for all the primary
> > stuff.  As I mentioned before, this might even mean getting rid of the
> > arbitrary hierarchical frames stuff.
> 
> Do all DBMS systems support the same set of primitive data types?
> 

To a first approximation.  At least, all the databases appear to support
the data types required by the SQL92 standard, and this standard
includes all the types you'd expect (several sizes of integer & floating
point variables, character strings, date fields, money fields, blobs,
etc).  

Of course, each database supports its own types beyond this, and they
may even have their own name for the SQL required types and treat the
SQL name as an alias.  Finally, the database files are binary
incompatible, of course.

-- Pat

-- 
      This message does not represent the policies or positions
	     of the Mayo Foundation or its subsidiaries.
  Patrick Spinler			email:	Spinler.Patrick@Mayo.EDU
  Mayo Foundation			phone:	507/284-9485