Groups > comp.os.linux.advocacy > #347786

Re: Can anyone here defend LibreOffice crapware against the masterful MS Office?

From	owl <owl@rooftop.invalid>
Newsgroups	comp.os.linux.advocacy
Subject	Re: Can anyone here defend LibreOffice crapware against the masterful MS Office?
Date	2016-03-27 18:37 +0000
Organization	O.W.L.
Message-ID	<x003afa3h.4p39@rooftop.invalid> (permalink)
References	<nd73he$i6u$1@dont-email.me> <dlolfbFftbU4@mid.individual.net> <nd78hq$63g$3@dont-email.me> <nd7jrq$3g8$1@dont-email.me>

Show all headers | View raw

DFS <nospam@dfs.com> wrote:
> On 3/26/2016 8:12 PM, Chris Ahlstrom wrote:
>> 7 wrote this copyrighted missive and expects royalties:
>>
>>> DFS wrote:
>>>
>>>> If I want to count all the tables and rows in any Access database, it's
>>>> just:
>>>>
>>>>      Dim db As Database, td as TableDef
>>>>      Dim tablesCnt As Integer, dbRecords As Long
>>>>      Set db = OpenDatabase(path to source file)
>>>
>>> The problem you have is clear.
>>>
>>> You became an idiot when you copy and pasted code.
>>>
>>> Your code doesn't work because you should have
>>> put the path in for the source file instead of
>>> copying and pasting code you don't understand.
>>>
>>> That is the problem with trolls like being allowed
>>> to go anywhere near a puter.
>>>
>>> Learn to code in Python. Its a lot smarter than you are.
>>>
>>> Its available free for Linux:
>>>
>>> http://www.distrowatch.com
>>> http://www.livecdlist.com
>>> http://www.ubuntu.com
>>
>> And even if Doof's "solution" is simpler, it's Microsoft-specific,
>> and not worth putting up with Windows.
> 
> Idiot (no quotes).  You "put up with Windows" most of your "career".
> 
> 
>> Any fool can djinn up their optimized "example", and challenge someone to
>> do better in another product.
> 
> So far, no one can do better in LibreOffice.  That's my point, Creepy. 
> See the Subject?
> 
> And what do you mean 'optimized'?  That's one of several acceptable ways 
> to do it, all offering excellent performance.
> 
> The slowest way is "SELECT COUNT(*)" on each table, but even that runs 
> in 0.15 seconds.
> 
> LibreOffice can't compete.
> 

But sqlite3 can.
And this is with select count(*) on each table.  It's written in C, but
there's a shell script speed comparsion of basically the same algorithm
at the bottom.  Imagine how fast it could be if I knew what I was doing?

anon@lowtide:~/scripts/database$ file dfs
dfs: SQLite 3.x database
anon@lowtide:~/scripts/database$ ls -lh dfs
-rw-r--r-- 1 anon anon 23M Mar 27 14:18 dfs
anon@lowtide:~/scripts/database$ time ./count
table count: 114
row count: 2099196

real	0m0.027s
user	0m0.004s
sys	0m0.020s
anon@lowtide:~/scripts/database$ time ./count
table count: 114
row count: 2099196

real	0m0.037s
user	0m0.016s
sys	0m0.020s
anon@lowtide:~/scripts/database$ time ./count
table count: 114
row count: 2099196

real	0m0.027s
user	0m0.012s
sys	0m0.012s
anon@lowtide:~/scripts/database$ sqlite3 dfs
SQLite version 3.8.7.1 2014-10-29 13:59:56
Enter ".help" for usage hints.
sqlite> create table blah0 (id integer primary key autoincrement, goo char(10));
sqlite> create table blah1 (id integer primary key autoincrement, goo char(10)); 
sqlite> create table blah3 (id integer primary key autoincrement, goo char(10)); 
sqlite> create table blah2 (id integer primary key autoincrement, goo char(10)); 
sqlite> insert into blah0 (goo) values ('hah');
sqlite> insert into blah0 (goo) values ('hah');
sqlite> insert into blah0 (goo) values ('hah');
sqlite> insert into blah1 (goo) values ('hah');
sqlite> insert into blah1 (goo) values ('hah');
sqlite> insert into blah1 (goo) values ('hah');
sqlite> insert into blah2 (goo) values ('hah');
sqlite> insert into blah2 (goo) values ('hah');
sqlite> insert into blah3 (goo) values ('hah');
sqlite> insert into blah3 (goo) values ('hah');
sqlite> .quit
anon@lowtide:~/scripts/database$ time ./count
table count: 118
row count: 2099206

real	0m0.026s
user	0m0.008s
sys	0m0.016s
anon@lowtide:~/scripts/database$ time ./count
table count: 118
row count: 2099206

real	0m0.022s
user	0m0.008s
sys	0m0.012s
anon@lowtide:~/scripts/database$ time ./count
table count: 118
row count: 2099206

real	0m0.042s
user	0m0.028s
sys	0m0.012s
anon@lowtide:~/scripts/database$ ./foo.sh
table count: 118
row count: 2099206
anon@lowtide:~/scripts/database$ time ./foo.sh
table count: 118
row count: 2099206

real	0m0.653s
user	0m0.168s
sys	0m0.108s
anon@lowtide:~/scripts/database$ time ./foo.sh
table count: 118
row count: 2099206

real	0m0.538s
user	0m0.084s
sys	0m0.060s
anon@lowtide:~/scripts/database$

Thread

csiph-web