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 _______________________________________________ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
