InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: InstantDB: InstantDB Performance Test


Fadoua

Attached are the files you need.

Regards

Peter Hearty
Lutris Technologies UK Ltd.
-----Original Message-----
From: Fadoua Ouerdiane <ouerdiane@internolix.com>
To: instantDB@enhydra.org <instantDB@enhydra.org>
Date: 08 May 2000 17:04
Subject: InstantDB: InstantDB Performance Test


Dear Peter

I thank you much for your excellent service.
Can you send me please the file "Perf.txt", for testing the performance of
my InstantDB Database.

I appreciate hour help and thank you in advance .

with best regards
============================
Dipl.-Inf. Fadoua Ouerdiane
manager

Internolix Tunisia
Immeuble l'arche du lac 2eme etage
2045 les berges du lac deTunis
Tel: +216 [0] 1 960 599
Fax: +216 [0] 1 960 576
email: internolix.gnet.tn

20000
d jdbc.idbDriver;

o jdbc:idb=sample.prp;

e SET EXPORT '.\\perf.log' FIXEDLENGTH COLNAMEHEADER ROWNUMBERS CONTROLCOL SUMMARYHEADER TRACE 2 CONSOLE;

e DROP TABLE auto1;
e IMPORT auto1 FROM "auto1.txt" USING "schema.ini";

e CREATE INDEX pkIndex ON auto1 (pk);

e UPDATE sample$db$Cols 
	SET cachecond=2,cacheamnt=100 
	WHERE colname="int1" 
	AND tableid=(
		SELECT t.tableid 
		FROM sample$db$tables t 
		WHERE tablename="auto1");
e UPDATE sample$db$Cols 
	SET cachecond=2,cacheamnt=100 
	WHERE colname="str1" 
	AND tableid=(
		SELECT t.tableid 
		FROM sample$db$tables t 
		WHERE tablename="auto1");
c close;


o jdbc:idb=sample.prp;
e SET EXPORT '.\\perf.log' FIXEDLENGTH COLNAMEHEADER ROWNUMBERS CONTROLCOL SUMMARYHEADER TRACE 2 CONSOLE;
;r 1000;
;c time;
e SELECT * from auto1 WHERE pk=9;
e SELECT * from auto1 WHERE pk=9;
c time;
e SELECT * from auto1 WHERE int1=9;
e SELECT * from auto1 WHERE int1=9;
c time;
e SELECT * from auto1 WHERE int2=9;
e SELECT * from auto1 WHERE int2=9;
c time;
e SELECT * from auto1 WHERE str1="9";
e SELECT * from auto1 WHERE str1="9";
c time;
e SELECT * from auto1 WHERE str2="9";
e SELECT * from auto1 WHERE str2="9";
c time;

e IMPORT auto1 FROM "auto1.txt" USING "schema.ini";

e SELECT * from auto1 WHERE pk=9;
e SELECT * from auto1 WHERE pk=9;
c time;
e SELECT * from auto1 WHERE int1=9;
e SELECT * from auto1 WHERE int1=9;
c time;
e SELECT * from auto1 WHERE int2=9;
e SELECT * from auto1 WHERE int2=9;
c time;
e SELECT * from auto1 WHERE str1="9";
e SELECT * from auto1 WHERE str1="9";
c time;
e SELECT * from auto1 WHERE str2="9";
e SELECT * from auto1 WHERE str2="9";
c time;

e IMPORT auto1 FROM "auto1.txt" USING "schema.ini";

e SELECT * from auto1 WHERE pk=9;
e SELECT * from auto1 WHERE pk=9;
c time;
e SELECT * from auto1 WHERE int1=9;
e SELECT * from auto1 WHERE int1=9;
c time;
e SELECT * from auto1 WHERE int2=9;
e SELECT * from auto1 WHERE int2=9;
c time;
e SELECT * from auto1 WHERE str1="9";
e SELECT * from auto1 WHERE str1="9";
c time;
e SELECT * from auto1 WHERE str2="9";
e SELECT * from auto1 WHERE str2="9";
c time;

e IMPORT auto1 FROM "auto1.txt" USING "schema.ini";

e SELECT * from auto1 WHERE pk=9;
e SELECT * from auto1 WHERE pk=9;
c time;
e SELECT * from auto1 WHERE int1=9;
e SELECT * from auto1 WHERE int1=9;
c time;
e SELECT * from auto1 WHERE int2=9;
e SELECT * from auto1 WHERE int2=9;
c time;
e SELECT * from auto1 WHERE str1="9";
e SELECT * from auto1 WHERE str1="9";
c time;
e SELECT * from auto1 WHERE str2="9";
e SELECT * from auto1 WHERE str2="9";
c time;
q SELECT COUNT(*) FROM auto1;

c close;

sample.prp

schema.ini