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

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

Path	csiph.com!xmission!news.alt.net!not-for-mail
From	owl <owl@rooftop.invalid>
Newsgroups	comp.os.linux.advocacy
Subject	Re: Can anyone here defend LibreOffice crapware against the masterful MS Office?
Date	Tue, 29 Mar 2016 20:43:01 +0000 (UTC)
Organization	O.W.L.
Lines	155
Message-ID	<fhju00a3f.ag@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> <x003afa3h.4p39@rooftop.invalid> <nd9o8v$t6i$1@dont-email.me> <hjgid02.aa4@rooftop.invalid> <ghjdi903t.at4og@rooftop.invalid> <ndeo22$54a$1@dont-email.me>
NNTP-Posting-Host	boom.rooftop.invalid
User-Agent	tin/2.2.1-20140504 ("Tober an Righ") (UNIX) (Linux/3.16.0-4-amd64 (x86_64))
Xref	csiph.com comp.os.linux.advocacy:348077

Show key headers only | View raw

DFS <nospam@dfs.com> wrote:
> On 03/29/2016 03:44 PM, owl wrote:
>> owl <owl@rooftop.invalid> wrote:
>>> DFS <nospam@dfs.com> wrote:
>>
>>>>
>>>> 2,099,101 rows
>>>> 114 tables
>>>> 971 columns
>>>>    text:      503
>>>>    boolean:   4
>>>>    numeric:   351
>>>>    date-time: 108
>>>>    binary:    5
>>>> 309 indexes (25 foreign keys)
>>>> 333,533,184 bytes on disk
>>>
>>> Didn't think there was that much porn in the universe.
>>>
>>>> Time: 0.17 seconds
>>>>
>>>
>>> I'll fiddle with larger number of columns, more rows, etc. and try
>>> to build a comparable test database.
>>>
>>
>> And...
>>
>> anon@lowtide:~/scripts/database$ file blah
>> blah: SQLite 3.x database
>> anon@lowtide:~/scripts/database$ ls -lh blah
>> -rw-r--r-- 1 anon anon 345M Mar 29 15:36 blah
>> anon@lowtide:~/scripts/database$ time ./count blah
>> table count: 114
>> row count: 2099196
>>
>> real  0m0.263s
>> user  0m0.092s
>> sys   0m0.168s
>> anon@lowtide:~/scripts/database$
> 
> 
> Kewl, but...
> 
> I calculated and reported 11 measures in 0.17 seconds.
> 
> You did 2 in 0.26 seconds.
> 

Yeah, it's slower.

> ACCESSPLUSVBAEQUALSWIN
> 
> And where's your code for 'count'?
> 

I posted the files earlier in tarball.  It included a README, the foo.sh
script, and a "create" file for building a dummy database.  Here's the
code for "count" (and remember, this is amateur hour):

-------------------------------------
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include "sqlite3.h"

#define BUFFER_SIZE 256

int table_count_callback(void *,int , char **, char **);
int table_names_callback(void *,int , char **, char **);
int row_count_callback(void *,int , char **, char **);

int row_count=0;
int t_count=0;
char table_names [1024*1024]={0};

int main(int argc, char *argv[]) {

 sqlite3 * db;
 char * sErrMsg = 0;
 const char s[2] = "\n";
 char table_count_SQL [BUFFER_SIZE] = {0};
 char table_names_SQL [BUFFER_SIZE] = {0};
 char row_count_SQL [BUFFER_SIZE] = {0};
 char *token;
 char token_SQL [BUFFER_SIZE] = {0};
 char *filename;

 if(argc!=2)
 {
   fprintf(stderr,"argc!=2\n");
   fprintf(stderr,"usage: %s <database>\n",argv[0]);
   exit(1);
 }

 filename=argv[1];

 sqlite3_open(filename, &db);

 sprintf(table_count_SQL, "select count(*) from sqlite_master where type='table' and name!='sqlite_sequence'");

 sqlite3_exec(db, table_count_SQL, table_count_callback, &t_count, &sErrMsg);

 printf("table count: %d\n",t_count);

 sprintf(table_names_SQL, "select name from sqlite_master where type='table' and name!='sqlite_sequence'");

 sprintf(row_count_SQL, "select count(*) from (select name from sqlite_master where type='table' and name !='sqlite_sequence')");

 sqlite3_exec(db,"BEGIN TRANSACTION",NULL,NULL,&sErrMsg);

 sqlite3_exec(db, table_names_SQL, table_names_callback, &row_count, &sErrMsg);

 token = strtok(table_names,s);

 while(token!=NULL)
 {
   sprintf(token_SQL,"select count(*) from %s",token);
   sqlite3_exec(db, token_SQL, row_count_callback, &row_count, &sErrMsg);
   token=strtok(NULL,s);
 }

 sqlite3_exec(db, "END TRANSACTION", NULL, NULL, &sErrMsg);

 printf("row count: %d\n",row_count);

 sqlite3_close(db);

 return 0;
}

int table_count_callback(void *pArg,int argc,char **argv,char **columnNames)
{
  *(int *)pArg+=atoi(argv[0]);
  return 0;
} 

int table_names_callback(void *pArg,int argc,char **argv,char **columnNames)
{
  strcat(table_names,*argv);
  strcat(table_names,"\n");
  return 0;
} 

int row_count_callback(void *pArg,int argc,char **argv,char **columnNames)
{
  int i=0;
  for (i=0;i<argc;i++)
  {
    *(int *)pArg+=atoi(argv[0]);
  }
  return 0;
} 

-------------------------------------

Thread

csiph-web