| |
| |
|
Stefan
Schnell | Hello Community,
following Listings have I for performance-Messung of Cheetah2 uses:
CompileMarkSeparation-Begin-----------------------------------------------------------------
$U Cheetah2.Unit.pcu
-Occupy resources----------------------------------------------------
xdbUseDLL
-Declare variables---------------------------------------------------
Declare FileName$, hdb&, Loop$, Adress&, Data$
FileName$ = "Test.dbf"
-Create string with data---------------------------------------------
Randomize
WhileLoop 1, 4096, 1
Data$ = Data$ + @Chr$(@Rnd(96) + 31)
EndWhile
-Create database-----------------------------------------------------
xdbCreate(@Addr(FileName$), "ID,N,9,0;MEMO,M,10,0")
-Open database-------------------------------------------------------
hdb& = xdbOpen(@Addr(FileName$), "")
-Add 20000 records with data-----------------------------------------
WhileLoop 1, 20000, 1
xdbClearBuffer(hdb&)
Loop$ = @Str$(&Loop)
xdbAssignField(hdb&, "ID", 0, @Addr(Loop$))
xdbAssignField(hdb&, "MEMO", 0, @Addr(Data$))
xdbAppendRecord(hdb&)
EndWhile
---------------------------------------------------------------------
Print
Print "Press any key to exit..."
WaitKey
-Close database------------------------------------------------------
xdbClose(hdb&)
-Free resources------------------------------------------------------
xdbFreeDLL
-End-------------------------------------------------------------------
End
so becomes a data base, bestehend a ID and one Memo-area with 20.000 Datensätzen created. each Memo-area is with one String, the 4096 Bytes big is, filled. The data base becomes 400.098 Bytes big and the pertinent Memo-boxes 92.160.002 Bytes (means 87,8 Megabyte).
to performance-Messung have I the following Program uses:
CompileMarkSeparation
here jumping the program 200 time to a beliebigen Datensatz and reads this from. for the jumping and Reading benötig Cheetah, with XProfan in the interpreter mode, ca. 0,025 sec.
shining still integrally acceptable To his.
Greeting
Stefan |
|
| |
| |
| |
|
|
Normann
Strübli | Hi Stefan,
wished the whole by me too test times but the Include Dbgview.inc have I
somehow not found - forget  .
How is because your Rechnerkonfiguration?
on the Homepage of Planetsquires can itself your Wrapper incidentally not any more
runterladen  - Paul ma bescheidgeben?
Greeting
Normann |
|
| |
| |
| |
|
|
Ragnar
Rehbein | i want none glaubenskrieg begin... but:
with the MS SQL-Server see The times similar from.
50 ms pub
200 ms over networking
2 ms over network if for request the autoincrement one index staid becomes !!!!
as MSDE free, very well documents, without DLL in profane useable, for almost everything I so white over datenbanken almost fehlerfrei and super steady.
to info one testprogramm for MSDE:
CompileMarkSeparationprint sqlinit(("Driver={SQL Server};Server=ragnar3;UID=sa;PWD=;Database=ordicomdb;"))
declare data$
Randomize
data$ = mkstr$("ABCD",1000)
WhileLoop 1, 4096, 1
Data$ = Data$ + @Chr$(@Rnd(96) + 31)
EndWhile
data$ = translate$(data$,"","")
sqlexec "drop table test",0
sqlexec "create table test (autoinc int identity, text varchar(5000))",0
print data$
cls
whileloop 1,20000
locate 0,0
print &loop
sqlexec "insert into test (text) values ("+Data$+") ",1
clearlist
endwhile
decimals 0
declare time&
time& = &gettickcount
whileloop 1,100
clearlist
sqlexec "select text from test where autoinc = "+str$(rnd(19999)+1),1
data$ = listboxitem$(2)
endwhile
print "time: ",(&gettickcount-time&)/100
waitinput
print data$
| 10/28/04 ▲ | |
|
| |
|
|
Stefan
Schnell | Hello Normann,
>but the Include Dbgview.inc have I somehow not found
to langer Time have I time in the Profan-Forum DebugView (of sysinternal) pictured and moreover a suitable Include-File, around the Debuggen with PrfDebug and a suitable spending in DebugView To vereinfachen. here The DbgView.inc for you:
CompileMarkSeparation
>How is because your Rechnerkonfiguration?
Getest have I the program now several Rechnern and Betriebssystemen:
WinXP Prof, HP, 1,6 GHz, 256 MByte RAM (the were The vorhandenen Results)
WinXP Home, Brandy, 2 GHz, 256 MByte RAM (was yet faster, 0,00xy sec)
Win 95 OSR 2, NoName, 266 MHz, 256 MByte RAM (was explicit slower)
any Results were however, related on The Rechnerkonfiguration, acceptable. :+)--
>on the Homepage of Planetsquires can itself your Wrapper incidentally not any more
runterladen
have Paul today tommorrow a slight modified Wrapper gesendet, füge it here as Attachment with.
Hello Ragnar,
>i want none glaubenskrieg begin... but:
I find that it a question the Einsatzes is. you have right, what The Microsoft Database Engine angeht, steady, free, quick and erprobt. a integrally important reason stops I but against: want You one customers really zumuten whom MSDE To install if only a small Datenbankinstallation ansteht? and the see I as klaren benefit of Cheetah, squat and requires of users No further activities. it comes, my visibility the items, even hereon on, for whom object or. which Zielgruppe the system certainly his should and here has Cheetah likewise How MSDE his Segment.
Greeting
Stefan |
|
| |
| |
| |
|
|
Stefan
Schnell | Hello Community,
Ingo made me recently in a Email on this Difference attentive, here small comparison of Cheetah To XProfan, the me yourself something surprised has:
lay out of 20000 Datensätzen à 3 boxes
Cheetah with XProfan in the Interpreter-mode 283 sec
XProfan in the Interpreter-mode 63 sec
Cheetah with XProfan with kompilierter File 41 sec
XProfan with kompilierter File 12 sec
Cheetah with XProfan as EXE 39 sec
XProfan as EXE 11 sec.
means, klarer Geschwindigkeitssieger is XProfan.
in the employment with XProfan is as Ansatz very To viewing whether The of XProfan offered functions suffice or not. should, straight in reference on Memo-boxes or others Feldtypen, further functions desired his, can Cheetah a gewinnbringende appendix his.
Greeting
Stefan |
|
| |
| |
| |
|
|
Normann
Strübli | Hello Stefan - Hello Community,
there Cheetah of my opinion to definitiv still The best data base is (the Performanceunterschied can itself of my opinion to only therefore explain, the XProfan for Dll-Aufrufe too long needed  )
have I a good Message for ALLE The Cheetah not yet uses having - because To valuable :
Cheetah is now FREEWARE ! ! !
means runterladen (Stefans Wrapper for XProfan not forget) and keen his.
Have fun with it. |
|
| |
| |
| |
|
|
CB | circa you The Search abzukürzen:
[...] 
Christian |
|
| |
| |
| |
|
|
Normann
Strübli | | Mist! - Yes very, whom Link want I still too post! thanks Chistian. |
|
| |
| |
| |
|
(445)
Deutsch
English
Français
Español
Italia