Skip to main content

Calvin answers: What is an index anyway?

There have been many articles (Discussions, posts, whatever) on how Visual FoxPro gets its speed from and how the VFP index actually works.

Calvin's most recent post,
What is an index anyway?, goes into full detail.

As a quick note on indexing and VFP 9, VFP 9 includes a new Binary index, useful for handling logical indices. The new BINARY index is smaller and also much faster.

INDEX ON DELETED() TAG DELETED BINARY

Example: Table with 8000 records (a few deleted)
INDEX ON DELETED() TAG DELETED : CDX file size was about 22K

INDEX ON DELETED() TAG DELETED BINARY: CDX file was only 4 K

There used to be a time when almost every application created an index for DELETED() until Chris Probst (referenced here on ProFox - I would link to the entire article but FoxPro advisor never put it online - hey Chris! did you know you could revise it and put it online yourself?) shattered the illusion that it would make things faster.

As it notes in the VFP9 help file, this new BINARY tag can be very helpful on networks or WANs where the old approach could cause performance problems.

Comments

Popular posts from this blog

Well, that explains CodePlex...

In a move that will be sure to anger open source (or rather anti-paid software, anti-Microsoft open source)  zealots, Microsoft is planning to buy GitHub . A year ago, I mused about why Microsoft would shut down CodePlex and how the world needs competing source code repositories to be strong. I'm not the only one per this Slashdot article  : "...   people have warned about GitHub becoming as large as it did as problematic because it concentrates too much of the power to make or break the open source world in a single entity, moreso because there were valid questions about GitHubs financial viability...." - Jacques Mattheij I will be interested in seeing this play out - whether developers jump ship or not. Have all the efforts Microsoft has made in pushing towards open source be seen as genuine or will all the zealots jump ship or maybe even attack? Microsoft's comment about why they shut down CodePlex referred to how spammers were using CodePlex. Well, GitHub

Attending Southwest Fox 2019 could change your life - Find out how

Southwest Fox is coming up in October and as I do every year, I spoke with the organizers Rick , Doug and Tamar on the FoxShow. Deadlines for Southwest Fox: Super-saver price (before July 1): $695 Early-bird price (before August 1): $770 Regular price (August 1 and later): $820 This year, I took a different approach with separate shows for each organizer but the main message is still the same : July 1st is their Go/No-Go date. Conferences don't talk about this very often. I don't think developers really question if Apple will hold their WWDC in June or Microsoft will hold their Build conference - but that's because those conferences are vendor-led. Southwest Fox is a community-driven conference - it's not driven by a company with an agenda. Listen to the interviews and you can hear how important each of the organizers feel the live connection between speakers and among attendees.

Seeking Truth

James Altucher's recent podcast episode with Norm Dworman hits on a variety of topics but the essence of the episode is really in the last fifteen minutes where they discuss the tone of the world, censorship and what the next steps are. Just the other day, I was asked about choosing sides and it was a very difficult decision. Not because it's a right/left scenario but rather that there are no true right vs left sides anymore. It's all personal attacks and very little ideas. Politics is no longer a debate or discussion on ideas but more personal conflicts. Social media simply amplifies this and the more the amplification is reported on, the worse it gets. We live in a world where media businesses care about eyeballs and since most people want to watch a train wreck, so that's what they put on the air. They mix fact and fiction ("based on a true story, mostly ) and people believe it as fact. I have a rough time thinking of past leaders (Churchill, Thatcher, even R