X-Received: by 2002:aed:2b64:: with SMTP id p91mr5861467qtd.202.1588732548724; Tue, 05 May 2020 19:35:48 -0700 (PDT)
X-Received: by 2002:a05:620a:1127:: with SMTP id p7mr6710033qkk.235.1588732548527; Tue, 05 May 2020 19:35:48 -0700 (PDT)
Path: csiph.com!xmission!news.snarked.org!border2.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: alt.php.sql
Date: Tue, 5 May 2020 19:35:48 -0700 (PDT)
In-Reply-To: <hhdiqdFi6hgU1@mid.individual.net>
Complaints-To: groups-abuse@google.com
Injection-Info: google-groups.googlegroups.com; posting-host=85.253.192.8; posting-account=RLbFgAoAAABlPh-gc0Wvab3sk10U9pg5
NNTP-Posting-Host: 85.253.192.8
References: <7f7c9834-7067-4985-9115-07f5a98f9f69@googlegroups.com> <6d01fd9a-4116-4d76-8aa4-9ba6303272fb@googlegroups.com> <eaac2039-fefc-4b28-ad50-e2be126143af@googlegroups.com> <hhaj7nFtbf4U1@mid.individual.net> <5e0b1a48-dbec-49ad-ae81-174b93a6c0b3@googlegroups.com> <hhaqluFchiU2@mid.individual.net> <92cf069a-0e25-48a0-85e3-73f6ad03450b@googlegroups.com> <hhdiqdFi6hgU1@mid.individual.net>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <9f28d0fd-7f9f-43be-b53b-8d3f0cdaecc3@googlegroups.com>
Subject: Re: PHP class based database system with some sql features(some queries)
From: kristjan1291983@gmail.com
Injection-Date: Wed, 06 May 2020 02:35:48 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Lines: 46
Xref: csiph.com alt.php.sql:40

teisip=C3=A4ev, 5. mai 2020 19:33.19 UTC+3 kirjutas J.O. Aho:
> On 05/05/2020 11.45, kristjan1291983@gmail.com wrote:
> > esmasp=C3=A4ev, 4. mai 2020 18:29.04 UTC+3 kirjutas J.O. Aho:
> >> On 04/05/2020 16.27, kristjan1291983@gmail.com wrote:
> >>
> >>> Yes, is will keep that in mind =E2=80=A6
> >>
> > Interesting=E2=80=A6.. My reply seems to have been deleted=E2=80=A6=E2=
=80=A6.
>=20
> No, it's not deleted, it's just that when you reply you reply only to=20
> one of the newsgroups, not both, I tend to add the missing newsgroup=20
> back, so if you are in the "wrong" newsgroup it may look your post is=20
> missing.
>=20
>=20
> >>> Btw have you tried it out yourself and if yes, then, what do you thin=
k of that ?
> >>
> >> I have to say no I haven't tried your db engine, at the moment I don't
> >> do much PHP and the database needs I have don't fit for recreating the
> >> database table file each time it's updated.
> >>
> > How you know my dbsys is slower ?
> > It takes about 10000/8 times less space.
>=20
>=20
> Test 1:
> Create a table with your primary key column "id" and a data column=20
> "name", do 10000 inserts into the table, with an increasing id number.
>=20
> Test 2:
> Create 3 tables, each can have a primary key column "id" and a data=20
> column "name", insert 100000 rows in each table (with id from 1 to=20
> 100000 on each table) and then make a select that joins all the 3 tables=
=20
> on the id.
>=20
> You can compare the time with sqlite.
>=20

What are you trying to say? How much faster can it get ?

> --=20
>=20
>   //Aho