Gnucash and root-account in MySQL
plongstaff at rogers.com
Sat Aug 8 12:09:04 EDT 2009
On August 8, 2009 04:37:26 am Colin Law wrote:
> 2009/8/8 Marcus Wolschon <Marcus at wolschon.biz>:
> - Hide quoted text -
> > What`s the point of not having that entry for the root-account?
> > "books" would just reference it`s guid.
> > It`s the one thing that would make referential integrity possible
> > when access-patterns/transactions have been changed to
> > allow for it at some point.
> > BTW: The database created has no index whatsoever.
> > Somehow that does not sound right too.
> The fact that a number of the tables do not have primary keys is also
> causing me problems.
"Database created has no index whatsoever". What do you mean? Indexes (I
assume you mean mysql) for each table based on primary key? postgresql
creates them automatically. I have added a few indexes on large tables to
improve query performance. What other indexes do you need?
"tables do not have primary keys" - Which tables?
More information about the gnucash-devel