More Speed in SQL?

[RyHoRuK]

Am 15. Mai 2004 um 17:02 Uhr schrieb Ruslan Zasukhin:

> On 5/15/04 5:37 PM, "RyHoRuK" <RyHoRuK at gmx.de> wrote:
>
>>> Try measure each from 4 commands
>>
>> meineDatenbank.TAnzeige.DeleteAllRecords
>> --> 0,05sec
>>
>> First SQLString-Building with InserINTO
>> --> 0,5-0,7sec
>>
>> Second SQLString-Building with InserINTO
>> --> 0,25-0,35sec
>>
>>
>>> How many records in tables?
>>> Cursors?
>>
>> Table.Buchungen = 7000
>> Table.Kategorien = 100
>> Table.Konten = 20
>>
>> my question is, can I optimize the process. Using other SQL or Better
>> InsertINTO. As I am right you told me, that I can't use One
>> SQL-Statement to geht the result. Thats the reason why I use a Table
>> where I generate a new Cursor after filling this table by this
>> InsertINTO-Statements.
>
> So I see, that you do select as join on few tables.
> Then you do INSERT of all that selected records into tmp table?
>
> How many records are selected? I.e. later copied?

close to 3000, but at the moment I can't say on what InsertINTO I have 
much more. I believe this is not important, because this could change 
all the time.


> What cache size you have? Try 8-15-20MB

Err=ValentinaInit(1*1024*1024,VC,"")


Err=ValentinaInit(5*1024*1024,VC,"")
meineDatenbank.TAnzeige.DeleteAllRecords
--> 0,05sec

First SQLString-Building with InserINTO
--> 0,4-0,5sec

Second SQLString-Building with InserINTO
--> 0,2-0,3sec


Err=ValentinaInit(10*1024*1024,VC,"")
meineDatenbank.TAnzeige.DeleteAllRecords
--> 0,05sec

First SQLString-Building with InserINTO
--> 0,2-0,3sec

Second SQLString-Building with InserINTO
--> 0,02-0,08sec

*hmm* it seems that this will help. I am not sure why my actual setting 
is 1MB.

Thanks for help


Claudius

-- 
G4/733 QS / MacOS X 10.3.3de / RB 5.2.4de or 5.5.1de/ Valentina 1.10.0
Homepage    http://www.sailer-online.de/pub/RealBasic/
Download    finale Versionen, Betaversionen auf der Homepage
RealBasic ListBoxes: [ I feel the need...the need for speed!!! ]