Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > alt.php.sql > #39

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

Cross-posted to 2 groups.

Show all headers | 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