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" 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: References: <7f7c9834-7067-4985-9115-07f5a98f9f69@googlegroups.com> <6d01fd9a-4116-4d76-8aa4-9ba6303272fb@googlegroups.com> <5e0b1a48-dbec-49ad-ae81-174b93a6c0b3@googlegroups.com> <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 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