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
Hello everyone
I have the same problem and the hard drive is kept busy.
linux mint 15
Takes an hour for me to do all, I switched from 16.0 to 15.8, this has fixed it for me.
Tom K8WDX
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
Cqrlog on Debian jessie/testing(x86),work very well
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
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Tnx Petr:
I'll work on my end. Perhaps I have a missing
or malfunctioning dependency.
Best 73's, Richard
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
No delay for me Mint 13 LTS 64 bit, works just fine in the new version.
Tom K8WDX
Hello everyone
I have the same problem.
LUBUNTU 12.04
CQRLOG 1.6.1
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
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
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