Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
The WORST Query, Performance Killer
Message
From
01/11/2002 12:16:29
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
The WORST Query, Performance Killer
Miscellaneous
Thread ID:
00717891
Message ID:
00717891
Views:
34
Maybe this time I have nothing important to do, so, I was thinking about a Query that could break your patient and system resources, can be this Query the Wrost <g>???
   CREATE CURSOR Temp (ID i)
   FOR I=1 to 600000
       INSERT INTO Temp VALUES (RAND()*100)
   ENDFOR
   
   **** This is the Wrost Query ****
   SELECT * FROM Temp WHERE ID ;
        IN (SELECT ID FROM TEMP WHERE ID IN(RAND()*100, RAND()*100))
Apoya a Visual FoxPro usandolo legalmente
--
¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º
Espartaco Palma Martínez
SysOp PortalFox
http://www.portalfox.com
esparta@portalfox.com
Next
Reply
Map
View

Click here to load this message in the networking platform