Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What is faster: insert from memvar or insert fields?
Message
From
25/07/2006 17:11:20
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01139366
Message ID:
01139949
Views:
17
>>Oh my! Good I asked to change your GUID generation.
>>
>>
>>* Try moving declaration into myGuid when you really have time to wait
>>Declare Integer UuidCreate In 'RPCRT4.dll' String @pguid
>>Declare Integer StringFromGUID2 In 'Ole32.dll' ;
>>  string rguid, String @lpsz, Integer cchMax
>>
>>start = SECONDS()
>>FOR ix=1 TO 100000
>>	x=myGUID()
>>ENDFOR
>>? SECONDS()-m.start
>>
>>FUNCTION myGUID
>>Local pGUID,rGUID
>>
>>pGUID=Replicate(Chr(0),16)
>>rGUID=Replicate(Chr(0),80)
>>
>>UuidCreate(@pGUID)
>>RETURN pGUID && 16 chars version - comment this and uncomment below for 38 version
>>*StringFromGUID2(pGUID,@rGUID,40)
>>*RETURN Strconv(Left(rGUID,76),6) && 38 chars version
>>
Cetin
>
>If I still want to use it in SP, how can I make sure I declared DLL only once? Using aDLLs would probably slow it down the same way as repeating declaration?

You could use db events but I wouldn't use it as an SP for this task.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform