performance & vacuum

You guys were correct of course. I've added a vacuum (which didn't work
because of that ecpg bug) and now it looks better but still much slower than
Oracle:

I needed 9 seconds and 748620 microseconds for the insert test.
I needed 5 seconds and 882221 microseconds for the selection&projection test.
I needed 10 seconds and 614912 microseconds for the join test.
I needed 0 seconds and 586992 microseconds for the update test.

Anyway, here's the patch on top of may last one to get vacuum going:

*** ./preproc/ecpg.c.orig Fri Feb 27 16:57:18 1998
--- ./preproc/ecpg.c Fri Feb 27 16:58:09 1998
***************
*** 58,65 ****
/* after the options there must not be anything but filenames */
for (fnr = optind; fnr < argc; fnr++)
{
! char *filename,
! *ptr2ext;
int ext = 0;

filename = mm_alloc(strlen(argv[fnr]) + 4);
--- 58,64 ----
/* after the options there must not be anything but filenames */
for (fnr = optind; fnr < argc; fnr++)
{
! char *filename, *ptr2ext;
int ext = 0;

filename = mm_alloc(strlen(argv[fnr]) + 4);
***************
*** 70,77 ****
--- 69,79 ----
/* no extension or extension not equal .pgc */
if (ptr2ext == NULL || strcmp(ptr2ext, ".pgc") != 0)
{
+ #if 0
+ /* dumps core under some circumstances */
if (ptr2ext == NULL)
ext = 1; /* we need this information a while later */
+ #endif
ptr2ext = filename + strlen(filename);
ptr2ext[0] = '.';
}
*** ./preproc/preproc.y.orig Fri Feb 27 16:56:00 1998
--- ./preproc/preproc.y Fri Feb 27 16:56:12 1998
***************
*** 607,613 ****
/* FIXME: instead of S_SYMBOL we should list all possible commands */
sqlcommand : S_SYMBOL | SQL_DECLARE;

! sqlstatement_words : sqlstatement_word
| sqlstatement_words sqlstatement_word;

sqlstatement_word : ':' symbol
--- 607,613 ----
/* FIXME: instead of S_SYMBOL we should list all possible commands */
sqlcommand : S_SYMBOL | SQL_DECLARE;

! sqlstatement_words : /* empty */
| sqlstatement_words sqlstatement_word;

sqlstatement_word : ':' symbol
*** ./test/perftest.pgc.orig Fri Feb 27 17:00:36 1998
--- ./test/perftest.pgc Fri Feb 27 17:01:39 1998
***************
*** 16,21 ****
--- 16,22 ----
usec+=1000000;
}
printf("I needed %ld seconds and %ld microseconds for the %s test.\n", sec, usec, text);
+ exec sql vacuum;
}

int
***************
*** 106,113 ****
exec sql drop index number1;

exec sql drop table perftest1;
-
- exec sql commit;

return (0);
}
--- 107,112 ----

Michael

--
Dr. Michael Meskes, Project-Manager | topsystem Systemhaus GmbH
meskes(at)topsystem(dot)de | Europark A2, Adenauerstr. 20
meskes(at)debian(dot)org | 52146 Wuerselen
Go SF49ers! Go Rhein Fire! | Tel: (+49) 2405/4670-44
Use Debian GNU/Linux! | Fax: (+49) 2405/4670-10