SQL - Do I need it ?

Need help? - Post here and we will find a solution for you.
Locked
GW4BLE
Novice Class
Posts: 18
Joined: 06 Aug 2014, 08:58

SQL - Do I need it ?

Post by GW4BLE »

As a newbie just experimenting with LOG4OM, not particularly au fait with some of the computer 'speak', I wonder what I might be missing by not using SQL . I just have SQLite enabled, and from my experience to date with 227,000 contacts in my log it seems to do all I need.

Any comments ?


Steve
GW4BLE
User avatar
G4POP
Log4OM Alpha Team
Posts: 10882
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: SQL - Do I need it ?

Post by G4POP »

Steve,
We usually re comment MySQL for large logs and rate Sqlite as OK for up to 150k QSO's, however if it's working OK I would stick with it - If it ain't broke don't fix it!

MySQL is very usefull where multiple stations need to log to the same database at the same time, like in a contest or DXPediition situation. Apart for that there are not many other advantages for the normal Amateur.
73 Terry G4POP
GW4BLE
Novice Class
Posts: 18
Joined: 06 Aug 2014, 08:58

Re: SQL - Do I need it ?

Post by GW4BLE »

Hi Terry,

Yes, agree with your sentiments - "if it ain't broke....."

I guess with SQL the database load / search may be faster ?, sure there's a few seconds, when for example this morning I needed to delete a couple of QSOs but I don't have an issue with that.

Steve
GW4BLE
Locked