Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
The WORST Query, Performance Killer
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
The WORST Query, Performance Killer
Divers
Thread ID:
00717891
Message ID:
00717891
Vues:
35
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform