Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Michel Levy
  Where is Michel Levy?
 
 France
 Michel Levy
 To: Victor Espina
  Where is Victor Espina?
 Rancagua
 Chile
 Victor Espina
 Tags
Subject: RE: Microsfot T-SQL Versus FoxPro Code
Thread ID: 394885 Message ID: 395606 # Views: 30 # Ratings: 1
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Thursday, January 16, 2014 10:21:18 AM         
   


> Mike, you are right. My statement was not clear enough. Indeed TSQL is very good handling large amounts of data, specially using temporary tables or table variables. What I meant was that TSQL is not particullary good at looping or scrolling on big data sets. For example, if you can acomplish a task handling data in chunks (for example, using INSERT SELECT) it will work really fast. But if you have to loop row by row on a large dataset using CURSOR-FETCH it will be a whole different story.
>
> I don't have any metrics to support this, only my personal experience through the last few years.
>
> Victor Espina
>
>
> >
> > --
> > Hi Victor,
> >
> > why do you say "TSQL its not particullary good handling big datasets" ? Do you have some example, with metrics? I experienced the exact opposite: in T-SQL, I may manipulate huge datasets that VFP could not even create
> >
> >
> > Michel L
>
>
>
> /* ---------------------------------- *\<br />> Victor J Espina S
> www.victorespina.com.ve/wiki

--
Ah, I understand now what you refer to, Victor.

The whole thing in T-SQL is that we need to quit our habits when dealing on a "row by row" or a "loop". There are only very few situations where one really need to fetch a cursor, or to loop in a while condition.
Recursive CTEs are often a solution, and if you have a table of dates, and a table of integers, you may find solutions with joins for the most part of the problems. Don't forget the CROSS APPLY, and you're done with 99.999% of your needs.

Michel L

ENTIRE THREAD

Microsoft T-SQL Versus FoxPro Code Posted by Cecil Champenois @ 1/8/2014 6:29:04 PM
RE: Microsfot T-SQL Versus FoxPro Code Posted by Borislav Borissov @ 1/8/2014 6:45:06 PM
RE: Microsfot T-SQL Versus FoxPro Code Posted by Michel Levy @ 1/8/2014 6:56:08 PM
RE: Microsfot T-SQL Versus FoxPro Code Posted by Cecil Champenois @ 1/8/2014 7:37:06 PM
RE: Microsfot T-SQL Versus FoxPro Code Posted by Michel Levy @ 1/8/2014 8:49:15 PM
RE: Microsfot T-SQL Versus FoxPro Code Posted by Cecil Champenois @ 1/9/2014 6:22:31 PM
RE: Microsfot T-SQL Versus FoxPro Code Posted by Cetin Basoz @ 1/10/2014 9:00:10 AM
RE: Microsfot T-SQL Versus FoxPro Code Posted by Leslie Botchway @ 1/10/2014 9:14:48 AM
RE: Microsfot T-SQL Versus FoxPro Code Posted by David Mustakim @ 1/10/2014 9:22:49 AM
RE: Microsfot T-SQL Versus FoxPro Code Posted by Cetin Basoz @ 1/11/2014 5:03:40 PM
RE: Microsfot T-SQL Versus FoxPro Code Posted by David Mustakim @ 1/11/2014 5:43:39 PM
RE: Microsfot T-SQL Versus FoxPro Code Posted by Cetin Basoz @ 1/15/2014 5:26:33 PM
RE: Microsfot T-SQL Versus FoxPro Code Posted by Cecil Champenois @ 1/10/2014 12:59:38 PM
RE: Microsfot T-SQL Versus FoxPro Code Posted by Cetin Basoz @ 1/15/2014 5:24:31 PM
RE: Microsfot T-SQL Versus FoxPro Code Posted by Cecil Champenois @ 1/16/2014 3:26:31 PM
RE: Microsfot T-SQL Versus FoxPro Code Posted by Cetin Basoz @ 1/16/2014 6:45:36 PM
RE: Microsfot T-SQL Versus FoxPro Code Posted by Pete Sass @ 1/8/2014 7:29:26 PM
RE: Microsfot T-SQL Versus FoxPro Code Posted by Cecil Champenois @ 1/9/2014 6:24:33 PM
RE: Microsfot T-SQL Versus FoxPro Code Posted by Cecil Champenois @ 1/13/2014 9:20:00 PM
RE: Microsfot T-SQL Versus FoxPro Code Posted by David Mustakim @ 1/13/2014 9:32:11 PM
RE: Microsfot T-SQL Versus FoxPro Code Posted by Cetin Basoz @ 1/8/2014 7:35:25 PM
RE: Microsfot T-SQL Versus FoxPro Code Posted by Victor Espina @ 1/8/2014 8:58:17 PM
RE: Microsfot T-SQL Versus FoxPro Code Posted by Michel Levy @ 1/10/2014 1:55:39 PM
RE: Microsfot T-SQL Versus FoxPro Code Posted by Victor Espina @ 1/16/2014 12:22:07 AM
RE: Microsfot T-SQL Versus FoxPro Code Posted by Michel Levy @ 1/16/2014 10:21:18 AM
RE: Microsfot T-SQL Versus FoxPro Code Posted by Victor Espina @ 1/16/2014 4:46:15 PM
RE: Microsfot T-SQL Versus FoxPro Code Posted by tom knauf @ 1/9/2014 6:07:46 PM