Gnucash + postgres.

[ALbert Gráfica - Suporte]

On Dec 2, 2010, at 9:57 AM, ALbert Gráfica - Suporte wrote:


> > sorry, no to import, to open.
> > 
> > Import it's quick, like 15 or 20 min.
> > 
> > i'm think in INSERT, UPDATE. etc.
> > 
> > when a try to open gnucasch he take slow.
> > 
> > but to open i expected a little more faster then that like 1 minute it's
> > great hmm?
So after you've imported the 58,000 records QIF, you quit gnucash and restart (or switch to another file/database and then reopen) it takes half an hour to load? Wow. 

Just after i import i try open the account(X - 57000), the big one, open realy quick. 

So i close, take a coffe(10 min later) and it became slow.


Again, how long does it take when you save as an XML file and reopen it? How big a file does it create, and do you have "compress data files" selected in Edit>Preferences>General?

XML - Tests. 

To open with postgres:
Start at : 18:51:36
End at: 19:17:32

I re-import the file to gnucash, and save file as xml. 

Without close, i try to open an acount call (X - 57000 trasactions)

Open time 5seg.

Now i close the file, and re-open the same file:

#gnucash

Time: 5Min 18seg

Try to open an acount call (X - 57000 trasactions)

Open time 5seg(same time)

File size 77M

"compress data files" - yeah!

What OS/Distro and what sort of hardware are you using?

I got 3 kind of OS. 


Windows XP. (On this is a HP pavlon 2200 [Core Duo 1.8 512 ram])

Centos 5.5 (Intel I5, 4gb RAM)

Mandriva 2010.1 x64 (Intel I5, 4gb RAM)
Postgresql8.4

All they got the same behavior(take to much time to open, same time!). 

Now i try samething diferent way:

Centos (The most import to run, and the only one i will work for now.)
#gnucash test
it can't open the file so now Ok no news for now. 
File --> Open --> postgres(configs)
I can see the accounts, but the Open window don't close, looks like it's tring open the trasactions(No news about that Oo). 

Some information about gnucash DB.
Just for informations. 
Tables 			Rows
accounts		167
billterms		0
books			1
budget_amounts		0
budgets			0
commodities		1
customers		0
employees		0
entries			0
invoices		0
jobs			0
lots			0
orders			0
prices			0
recurrences		0
schedxactions		0
slots			0
splits			0
taxtable_entries	0
taxtables		0
transactions		57720
vendors			0
versions		22

Just to info:

libdbi-dbd-pgsql-0.8.1a-1.2.2
libdbi-drivers-0.8.1a-1.2.2
libdbi-0.8.1-2.1
libdbi-devel-0.8.1-2.1



Please remember to copy the list on your replies: Use "reply all" or, if your mail client supports it, "reply list".

Regards,
John Ralls