Is there ANYTHING you like or have ever liked about VFP? Would it help if
VFP saved its tables in XML format?

-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf
Of Stephen Russell
Sent: Thursday, 15 January 2009 3:48 AM
To: ProFox Email List
Subject: Re: [NF] M$ is pushing ahead for performance

On Wed, Jan 14, 2009 at 10:55 AM, MB Software Solutions General
Account <[email protected]> wrote:
> Stephen Russell wrote:
>> This is why C/S is superior then xBase.  Your server is asked for what
>> the client needs, instead of pushing the entire index file and usually
>> the entire dbf to the client for every little request.
>
> C'mon, Steve...many times it's been said (and proven, iirc, by some
> great devs) that it doesn't push the entire DBF to the client.  FUD
comment.
----------------------------

please tell me how you can pull data out of thin air if the rows are
not present?

Do you have a table for States?  If you do, and your going to have a
state drop down list what is not being brought down to the client?

I would guess that there are a lot of these situations on every app
written.  You just don't think of it.  You only think of my orders
table and the OrderDetails.

I wonder how you think that if the dbf file is 100 meg and your
scanning that you don't get the bloody thing in entirety?

I wonder if your indexes are poorly designed <big laugh here because
having a lot is not the answer> that the data engine is not doing a
table scan after your joins in the linking subsets / tables, let alone
how it decides what to filter on in your where clause.

Because the table is local it rips through real fast.

What does everybody know about sql joins from a VFP POV/  What is
actual and what is suggested, made up, to the extreme of pure bull?
Everyone here sees that M$ bought FP to pull index technology to SQL
Server.  If that is so why are there real hard rules to what indexes
are consumed in a query, and that you don't get a bunch of indexes for
a single table like you think happens in VFP?




-- 
Stephen Russell
Sr. Production Systems Programmer
First Horizon Bank
Memphis TN

901.246-0159


[excessive quoting removed by server]

_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Reply via email to