Performance

R

Rob

Guest
I am using the latest dadabik version 2.2.1. I have 5 tables each with about this many records:

(Number of records in the database: 836457123)

Dadabik only does querys on these tables. The data is inserted with LOAD DATA from MySQL. The tables have 6 columns with indexes on three fields that you can query on.

I notice that If I do a generic query using my own html/php page data is returned faster than in dadabik?

But I like dadabik's looks and features compared to my own.... So my question is :

Is there any tweaking I can do to the app."dadabik" to fine tune it for speed?

My server is a Dell 2550 with 4 gb ram and 2 pent. III cpu's.. with a dell power vault raid.

 
E

Eugenio

Guest
Rob wrote:

> I am using the latest dadabik version 2.2.1. I have 5 tables
> each with about this many records:
>
> (Number of records in the database: 836457123)

[...]

Honestly I have never tried DaDaBIK with so much records, anyway with the new version 3.0 which I'm going to release, the speed of DaDaBIK is dramatically increased in case of databases containing a lot of table; probably you can achieve better results also if you have only few tables.

Let me know your performance results when the new version will be available.



(Latest version of DaDaBIK when this message was posted: 2.2.1)
 
R

Rob

Guest
Thanks for the response.. Thanks for the new version..

Will let you know how 3.0 dadabik does with 900 million records.

rob
 
Top