Re: PHP class based database system with some sql features(some queries)

Path	csiph.com!4.us.feeder.erje.net!2.eu.feeder.erje.net!feeder.erje.net!news.uzoreto.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From	"J.O. Aho" <user@example.net>
Newsgroups	alt.php.sql, alt.comp.lang.php
Subject	Re: PHP class based database system with some sql features(some queries)
Date	Tue, 5 May 2020 18:33:16 +0200
Lines	39
Message-ID	<hhdiqdFi6hgU1@mid.individual.net> (permalink)
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>
Mime-Version	1.0
Content-Type	text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding	8bit
X-Trace	individual.net 6goE7vXTdWKClZFCh/tQ+wKcl17II5Cqh/Uo9yzLmaCDBsZxYy
Cancel-Lock	sha1:GHAT5ahwWioPIDTm6GSK456puW0=
User-Agent	Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.7.0
In-Reply-To	<92cf069a-0e25-48a0-85e3-73f6ad03450b@googlegroups.com>
Content-Language	en-US-large
Xref	csiph.com alt.php.sql:39 alt.comp.lang.php:33

Cross-posted to 2 groups.

Show key headers only | View raw

On 05/05/2020 11.45, kristjan1291983@gmail.com wrote:
> esmaspäev, 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 …
>>
> Interesting….. My reply seems to have been deleted…….

No, it's not deleted, it's just that when you reply you reply only to 
one of the newsgroups, not both, I tend to add the missing newsgroup 
back, so if you are in the "wrong" newsgroup it may look your post is 
missing.

>>> Btw have you tried it out yourself and if yes, then, what do you think 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.

Test 1:
Create a table with your primary key column "id" and a data column 
"name", do 10000 inserts into the table, with an increasing id number.

Test 2:
Create 3 tables, each can have a primary key column "id" and a data 
column "name", insert 100000 rows in each table (with id from 1 to 
100000 on each table) and then make a select that joins all the 3 tables 
on the id.

You can compare the time with sqlite.

-- 

  //Aho

Back to alt.php.sql | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Easy php db system, that saves data to files and needs only one file( itself) Kristjan Robam <robamman2020@hotmail.com> - 2020-03-20 12:28 -0700
  Re: Easy relative php db system, that saves data to files and needs only one file( itself) Kristjan Robam <robamman2020@hotmail.com> - 2020-03-20 22:29 -0700
  Easy object based relational php database system that saves data to files only needing 1 file (the system php file) Kristjan Robam <robamman2020@hotmail.com> - 2020-03-21 06:00 -0700
    PHP class based database system with some sql features(some queries) kristjan1291983@gmail.com - 2020-05-04 01:33 -0700
      Re: PHP class based database system with some sql features(some queries) "J.O. Aho" <user@example.net> - 2020-05-04 15:21 +0200
        Re: PHP class based database system with some sql features(some queries) "J.O. Aho" <user@example.net> - 2020-05-04 17:29 +0200
          Re: PHP class based database system with some sql features(some queries) kristjan1291983@gmail.com - 2020-05-05 02:45 -0700
            Re: PHP class based database system with some sql features(some queries) kristjan1291983@gmail.com - 2020-05-05 08:01 -0700
            Re: PHP class based database system with some sql features(some queries) "J.O. Aho" <user@example.net> - 2020-05-05 18:33 +0200
              Re: PHP class based database system with some sql features(some queries) kristjan1291983@gmail.com - 2020-05-05 19:35 -0700
          Re: PHP class based database system with some sql features(some queries) "J.O. Aho" <user@example.net> - 2020-05-05 18:19 +0200

csiph-web