Very slow QSL manager updates

13 posts / 0 new
Last post
k3dcw
Very slow QSL manager updates

I never noticed this before with older versions, but I recently reinstalled Linux Mint 13 and CQRlog v1.6.0.

Occasionally, as expected, it asks me to download updated QSL manager info; but when it does so the download/update is VERY slow, taking several 10's of minutes.

I'm running on a very fast internet connection, so that isn't the issue.

Any ideas what I can do to speed this up? While the QSL manager info is downloading, CQRlog is unusable, of course.

In the 3 or so minutes it has taken me to type this posting, I've gone from 6500 to 8100 on the download count...pretty slow!

Thanks in advance,

Dave
K3DCW

sv2cuu
Very slow QSL manager updates

Hello everyone
I have the same problem and the hard drive is kept busy.

linux mint 15

k8wdx
Takes an hour for me to do

Takes an hour for me to do all, I switched from 16.0 to 15.8, this has fixed it for me.

Tom K8WDX

ky7q
Very slow QSL manager updates

Petr:

A cqrlog version i386-1.6.1 on Debian Wheezy testing is continuing ( as did 1.6.0)
with the minor annoyance of very slow QSL manager downloads (aborted after 20
minutes ). The same 1.6.1 version ( also 1.6.0 ) on Ubuntu 13.04 completes the
download in less than 5 seconds. I multiboot both os's while completing a migration
to Debian. Could there be a problem with the i386 deb or a debian incompatibility?
Strangely, during the debian download the hd is excessively noisey.

Thanks for your good work

Richard, KY7Q

CX1FK
Cqrlog on Debian jessie

Cqrlog on Debian jessie/testing(x86),work very well

ok2cqr
ok2cqr's picture
Re: Very slow QSL manager updates

Richard,

I have no idea what could be wrong. From my point of view it seems after every insert into database it makes also commit. That will be the reason. I have no idea why is this happening. The code calls start transaction, does the import and calls commit. The information in the dialog was not repainted, download is fine, problem is with the import to database :(.

73 Petr

ky7q
Re: Very slow QSL manager updates

Tnx Petr:

I'll work on my end. Perhaps I have a missing
or malfunctioning dependency.

Best 73's, Richard

k3dcw
For what it matters, Petr, I

For what it matters, Petr, I'm seeing this on Linux Mint LTS (Maya/LM 13) running 64-bit. It could be a 64-bit problem since some of those reporting just everything working seem to be running 32-bit systems.

And I'm still seeing it in the latest version, although it does seem to be a bit faster.

73

Dave

k8wdx
No delay for me Mint 13 LTS

No delay for me Mint 13 LTS 64 bit, works just fine in the new version.

Tom K8WDX

hg7wav
Hello everyone

Hello everyone
I have the same problem.

LUBUNTU 12.04
CQRLOG 1.6.1

on5hb
on5hb's picture
goto ~/.config/cqrlog

goto ~/.config/cqrlog/databases/my.cnf
Then add this:
key_buffer              = 256M
max_allowed_packet      = 16M
thread_stack            = 192K
thread_cache_size       = 8
max_connections        = 200
table_cache            = 256
thread_concurrency     = 4
Save and restart CQRLOG, here it's super fast now.
 
 

Greetings, Bas. ON5HB

on5hb
on5hb's picture
As for the commit problem,

As for the commit problem, this may be the answer:
http://dev.mysql.com/doc/refman/5.1/en/innodb-tuning.html
Turn auto-commit off, then insert the data and commit after.
But what I don't understand, why are you using InnoDB? MyISAM is ten times faster and more bullitproof.
Can't you consider moving all tables to MyISAM? It's also far easier to move everything from machine to machine, as you can simply copy the directory.
Even is you seperate the database between machines.
Thanks.
 
 

Greetings, Bas. ON5HB

on5hb
on5hb's picture
Adding the parameters didn't

Adding the parameters didn't do anything for the SQL-manager import, but it did speed up the rest of this excelent logging-program.

Greetings, Bas. ON5HB