473,692 Members | 2,160 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Need faster access to Visual FoxPro tables

cj
I'm trying to forge ahead with Visual Basic .Net but recently I've suffered
several major set backs in demonstrating VB is the future and we should move
from Visual FoxPro.

I really need to find help on this is. My current problem is I've got to
display some Visual FoxPro data from stand alone tables in a datagrid (Widows
App). The main table is 50 meg with 540,000+ records. 1 of the others
joined to it is 11 meg and the other 2 are insignificant in comparison. The
legacy FoxPro programmers here demonstrate instant retrieval into their
equilevent of a datagrid. FroxPro can then take a value, find it in the data
and jump down to the first occurance is leaving the user free to browse up
and down the data from that point. It acts like it has the whole resulting
datatable in memory and everything is pretty instantanious.

Using Oledb and the appropriate sql command I can display the data in a
datagrid in VB but it takes 30 to 40 seconds. My boss was not impressed.
I'm still working on the search behavior.

I'm not a VFP programmer. I need to show VB .Net can handle large amounts
of data just as fast and good as VFP or I'll have to learn VFP. I hope MS
hasn't lead me astray with it's hype of VB and .Net being so useful.

One might wonder why I have to use the VFP databases. Well w/o it's own
database VB.Net has to use something. Also the data actually comes to us in
fixed lenght field ascii files which are imported and modified by legacy VFP
systems ending in these VFP tables. And, lastly the boss wants me to use the
VFP tables. This system will be used my many people accessing (read-only)
the same tables.

Any help would be appreciated.
Nov 23 '05 #1
9 3322
cj wrote:
I'm trying to forge ahead with Visual Basic .Net but recently I've suffered
several major set backs in demonstrating VB is the future and we should move
from Visual FoxPro.

I really need to find help on this is. My current problem is I've got to
display some Visual FoxPro data from stand alone tables in a datagrid (Widows
App). The main table is 50 meg with 540,000+ records. 1 of the others
joined to it is 11 meg and the other 2 are insignificant in comparison. The
legacy FoxPro programmers here demonstrate instant retrieval into their
equilevent of a datagrid. FroxPro can then take a value, find it in the data
and jump down to the first occurance is leaving the user free to browse up
and down the data from that point. It acts like it has the whole resulting
datatable in memory and everything is pretty instantanious.

Using Oledb and the appropriate sql command I can display the data in a
datagrid in VB but it takes 30 to 40 seconds. My boss was not impressed.
I'm still working on the search behavior.

I'm not a VFP programmer. I need to show VB .Net can handle large amounts
of data just as fast and good as VFP or I'll have to learn VFP. I hope MS
hasn't lead me astray with it's hype of VB and .Net being so useful.

One might wonder why I have to use the VFP databases. Well w/o it's own
database VB.Net has to use something. Also the data actually comes to us in
fixed lenght field ascii files which are imported and modified by legacy VFP
systems ending in these VFP tables. And, lastly the boss wants me to use the
VFP tables. This system will be used my many people accessing (read-only)
the same tables.

Any help would be appreciated.


You will not get vb.net to access the VFP tables as fast as VFP will,
period. The advantages of vb.net over VFP is not speed of accessing the
data. vb.net uses disconnected data access model. The advantages of
vb.net over VFP are many, some would be: when you wanted to put data on
the web, have remote users access the data, or having many users
accessing the data at once. VFP is optimized to access its own data and
referencing it through an any other method will be slower.

I worked for a company that sold a product that was used on small 3
person network in retail stores, in this sense moving to .net didn't
make any sense at all. Once stores started wanted to connect several
together, vb.net won over and we migrated to a version of SQL.

Chris
Nov 23 '05 #2
Learn VFP - it's an awesome development tool!

T

cj wrote:
I'm trying to forge ahead with Visual Basic .Net but recently I've suffered
several major set backs in demonstrating VB is the future and we should move
from Visual FoxPro.

I really need to find help on this is. My current problem is I've got to
display some Visual FoxPro data from stand alone tables in a datagrid (Widows
App). The main table is 50 meg with 540,000+ records. 1 of the others
joined to it is 11 meg and the other 2 are insignificant in comparison. The
legacy FoxPro programmers here demonstrate instant retrieval into their
equilevent of a datagrid. FroxPro can then take a value, find it in the data
and jump down to the first occurance is leaving the user free to browse up
and down the data from that point. It acts like it has the whole resulting
datatable in memory and everything is pretty instantanious.

Using Oledb and the appropriate sql command I can display the data in a
datagrid in VB but it takes 30 to 40 seconds. My boss was not impressed.
I'm still working on the search behavior.

I'm not a VFP programmer. I need to show VB .Net can handle large amounts
of data just as fast and good as VFP or I'll have to learn VFP. I hope MS
hasn't lead me astray with it's hype of VB and .Net being so useful.

One might wonder why I have to use the VFP databases. Well w/o it's own
database VB.Net has to use something. Also the data actually comes to us in
fixed lenght field ascii files which are imported and modified by legacy VFP
systems ending in these VFP tables. And, lastly the boss wants me to use the
VFP tables. This system will be used my many people accessing (read-only)
the same tables.

Any help would be appreciated.

Nov 23 '05 #3
cj
No, Clipper is an awesome development tool. :)

"tomb" wrote:
Learn VFP - it's an awesome development tool!

T

cj wrote:
I'm trying to forge ahead with Visual Basic .Net but recently I've suffered
several major set backs in demonstrating VB is the future and we should move
from Visual FoxPro.

I really need to find help on this is. My current problem is I've got to
display some Visual FoxPro data from stand alone tables in a datagrid (Widows
App). The main table is 50 meg with 540,000+ records. 1 of the others
joined to it is 11 meg and the other 2 are insignificant in comparison. The
legacy FoxPro programmers here demonstrate instant retrieval into their
equilevent of a datagrid. FroxPro can then take a value, find it in the data
and jump down to the first occurance is leaving the user free to browse up
and down the data from that point. It acts like it has the whole resulting
datatable in memory and everything is pretty instantanious.

Using Oledb and the appropriate sql command I can display the data in a
datagrid in VB but it takes 30 to 40 seconds. My boss was not impressed.
I'm still working on the search behavior.

I'm not a VFP programmer. I need to show VB .Net can handle large amounts
of data just as fast and good as VFP or I'll have to learn VFP. I hope MS
hasn't lead me astray with it's hype of VB and .Net being so useful.

One might wonder why I have to use the VFP databases. Well w/o it's own
database VB.Net has to use something. Also the data actually comes to us in
fixed lenght field ascii files which are imported and modified by legacy VFP
systems ending in these VFP tables. And, lastly the boss wants me to use the
VFP tables. This system will be used my many people accessing (read-only)
the same tables.

Any help would be appreciated.

Nov 23 '05 #4
cj
That's what I was afraid of. Still a lot of demand for non-web related
programming. Seems a shame VB can't bring more to the table. Why couldn't
they give it it's own db language/format then it could do both connected and
disconnected data access.
"Chris" wrote:
cj wrote:
I'm trying to forge ahead with Visual Basic .Net but recently I've suffered
several major set backs in demonstrating VB is the future and we should move
from Visual FoxPro.

I really need to find help on this is. My current problem is I've got to
display some Visual FoxPro data from stand alone tables in a datagrid (Widows
App). The main table is 50 meg with 540,000+ records. 1 of the others
joined to it is 11 meg and the other 2 are insignificant in comparison. The
legacy FoxPro programmers here demonstrate instant retrieval into their
equilevent of a datagrid. FroxPro can then take a value, find it in the data
and jump down to the first occurance is leaving the user free to browse up
and down the data from that point. It acts like it has the whole resulting
datatable in memory and everything is pretty instantanious.

Using Oledb and the appropriate sql command I can display the data in a
datagrid in VB but it takes 30 to 40 seconds. My boss was not impressed.
I'm still working on the search behavior.

I'm not a VFP programmer. I need to show VB .Net can handle large amounts
of data just as fast and good as VFP or I'll have to learn VFP. I hope MS
hasn't lead me astray with it's hype of VB and .Net being so useful.

One might wonder why I have to use the VFP databases. Well w/o it's own
database VB.Net has to use something. Also the data actually comes to us in
fixed lenght field ascii files which are imported and modified by legacy VFP
systems ending in these VFP tables. And, lastly the boss wants me to use the
VFP tables. This system will be used my many people accessing (read-only)
the same tables.

Any help would be appreciated.


You will not get vb.net to access the VFP tables as fast as VFP will,
period. The advantages of vb.net over VFP is not speed of accessing the
data. vb.net uses disconnected data access model. The advantages of
vb.net over VFP are many, some would be: when you wanted to put data on
the web, have remote users access the data, or having many users
accessing the data at once. VFP is optimized to access its own data and
referencing it through an any other method will be slower.

I worked for a company that sold a product that was used on small 3
person network in retail stores, in this sense moving to .net didn't
make any sense at all. Once stores started wanted to connect several
together, vb.net won over and we migrated to a version of SQL.

Chris

Nov 23 '05 #5
Hi CJ,

Please see my answer in ....vb.data.

Also, there's always a "best tool for the job" and trying to argue switching
from Fox to VB based on performance only may not be successful. However,
..NET offers security, memory management, great MSFT support going forward, a
larger pool of job applicants for the future of your app, etc.

Finally, you are right that VB does not have its own database, but choosing
DBFs because you "have to use something" may not be the best option going
forward. Fox data does not have "real" security and can be prone to
corruption, especially with poor connectivity and bad user habits. With SQL
Server Express being free and having greater capacities than MSDE, it's an
excellent and cost-effective choice. Many Fox developers don't use DBFs at
all but rather choose whichever version of SQL Server fits their needs,
including their need for a low price. If you don't want to re-write the
import/modify process for the DBFs you could keep the legacy stuff and use
something on the SQL Server side to import to that DB.

I'm a Visual FoxPro developer and I love the Fox, but it has its downsides
(and upsides, of course), just like any other database and/or development
tool.

I think the boss needs to think a few years into the future and decide,
based on that, the direction he needs to take.
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
ci************* *@msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden
"cj" <cj@discussions .microsoft.com> wrote in message
news:6B******** *************** ***********@mic rosoft.com...
I'm trying to forge ahead with Visual Basic .Net but recently I've
suffered
several major set backs in demonstrating VB is the future and we should
move
from Visual FoxPro. I'm not a VFP programmer. I need to show VB .Net can handle large amounts
of data just as fast and good as VFP or I'll have to learn VFP. I hope MS
hasn't lead me astray with it's hype of VB and .Net being so useful.

One might wonder why I have to use the VFP databases. Well w/o it's own
database VB.Net has to use something. Also the data actually comes to us
in
fixed lenght field ascii files which are imported and modified by legacy
VFP
systems ending in these VFP tables. And, lastly the boss wants me to use
the
VFP tables. This system will be used my many people accessing (read-only)
the same tables.

Any help would be appreciated.

Nov 23 '05 #6
cj wrote:
No, Clipper is an awesome development tool. :)

"tomb" wrote:


Damn right!

To the original poster, have you seen Vulcan.NET? Vulcan.NET compiler is a CLI-compliant .NET
language compiler that uses 99% Clipper/FoxPro style language.

http://www.vulcandotnet.com/
http://www.vulcandotnet.com/VulcanDB...ile_Device.htm
Nov 23 '05 #7
cj
Thanks but I think it's VB .net for me now for a few years untill MS changes
it AGAIN.
"Mark" wrote:
cj wrote:
No, Clipper is an awesome development tool. :)

"tomb" wrote:


Damn right!

To the original poster, have you seen Vulcan.NET? Vulcan.NET compiler is a CLI-compliant .NET
language compiler that uses 99% Clipper/FoxPro style language.

http://www.vulcandotnet.com/
http://www.vulcandotnet.com/VulcanDB...ile_Device.htm

Nov 23 '05 #8
cj
Understood.

"Cindy Winegarden" wrote:
Hi CJ,

Please see my answer in ....vb.data.

Also, there's always a "best tool for the job" and trying to argue switching
from Fox to VB based on performance only may not be successful. However,
..NET offers security, memory management, great MSFT support going forward, a
larger pool of job applicants for the future of your app, etc.

Finally, you are right that VB does not have its own database, but choosing
DBFs because you "have to use something" may not be the best option going
forward. Fox data does not have "real" security and can be prone to
corruption, especially with poor connectivity and bad user habits. With SQL
Server Express being free and having greater capacities than MSDE, it's an
excellent and cost-effective choice. Many Fox developers don't use DBFs at
all but rather choose whichever version of SQL Server fits their needs,
including their need for a low price. If you don't want to re-write the
import/modify process for the DBFs you could keep the legacy stuff and use
something on the SQL Server side to import to that DB.

I'm a Visual FoxPro developer and I love the Fox, but it has its downsides
(and upsides, of course), just like any other database and/or development
tool.

I think the boss needs to think a few years into the future and decide,
based on that, the direction he needs to take.
--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
ci************* *@msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden
"cj" <cj@discussions .microsoft.com> wrote in message
news:6B******** *************** ***********@mic rosoft.com...
I'm trying to forge ahead with Visual Basic .Net but recently I've
suffered
several major set backs in demonstrating VB is the future and we should
move
from Visual FoxPro.

I'm not a VFP programmer. I need to show VB .Net can handle large amounts
of data just as fast and good as VFP or I'll have to learn VFP. I hope MS
hasn't lead me astray with it's hype of VB and .Net being so useful.

One might wonder why I have to use the VFP databases. Well w/o it's own
database VB.Net has to use something. Also the data actually comes to us
in
fixed lenght field ascii files which are imported and modified by legacy
VFP
systems ending in these VFP tables. And, lastly the boss wants me to use
the
VFP tables. This system will be used my many people accessing (read-only)
the same tables.

Any help would be appreciated.


Nov 23 '05 #9
Learn VFP!

"cj" wrote:
I'm trying to forge ahead with Visual Basic .Net but recently I've suffered
several major set backs in demonstrating VB is the future and we should move
from Visual FoxPro.

I really need to find help on this is. My current problem is I've got to
display some Visual FoxPro data from stand alone tables in a datagrid (Widows
App). The main table is 50 meg with 540,000+ records. 1 of the others
joined to it is 11 meg and the other 2 are insignificant in comparison. The
legacy FoxPro programmers here demonstrate instant retrieval into their
equilevent of a datagrid. FroxPro can then take a value, find it in the data
and jump down to the first occurance is leaving the user free to browse up
and down the data from that point. It acts like it has the whole resulting
datatable in memory and everything is pretty instantanious.

Using Oledb and the appropriate sql command I can display the data in a
datagrid in VB but it takes 30 to 40 seconds. My boss was not impressed.
I'm still working on the search behavior.

I'm not a VFP programmer. I need to show VB .Net can handle large amounts
of data just as fast and good as VFP or I'll have to learn VFP. I hope MS
hasn't lead me astray with it's hype of VB and .Net being so useful.

One might wonder why I have to use the VFP databases. Well w/o it's own
database VB.Net has to use something. Also the data actually comes to us in
fixed lenght field ascii files which are imported and modified by legacy VFP
systems ending in these VFP tables. And, lastly the boss wants me to use the
VFP tables. This system will be used my many people accessing (read-only)
the same tables.

Any help would be appreciated.
Jun 27 '08 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
2752
by: Colin Colin | last post by:
We migrated our intranet site from IIS4 NT4 (\\GHCNT8) to a Windows 2003 server with IIS6 (\\NT58) using the IIS Migration Tools. I have a few ASP pages that access Foxpro data on a different server. I downloaded the Visual Foxpro ODBC Driver from MSDN. I exported (from the registry) the ODBC entries from the old server and imported them onto the newserver. I setup the Internet user guest account with rights where the Foxpro data is...
1
2333
by: jdola | last post by:
I have a customer that is using Access to create reports from FoxPro tables. We started noticing problems with the indexes on the FoxPro tables. It is to the point where we have to delete and rebuild the indexes on a nightly basis. We cannot determine if Access is the culprit and I have not been able to look at the Access reports and determine how he is linking to the tables. I realize this is not much to go on, but does anyone see any...
2
6599
by: Salad | last post by:
OS = WinXP & Win98. Access = A97 & AXP Q1) Where can I find the VFP ODBC driver at Microsoft. I have been working developing an app in Access that will link to some DOS FoxPro tables. I have been doing my development work in A97 but the folks have AXP at their site. As near as I can tell, the FoxPro driver has been discarded from A97 and replaced with ODBC in A2K onward
3
3079
by: Mike Wilson | last post by:
Is there a way to open an OLE DB database from within Access? I would like to use the Access GUI with its table and query explorer to examine a database only available through an OLEDB provider interface. I have seen several references on how to open an OLE DB database through VBA/ADO code but I wouldn't know how to go from there to actually have the database available in the Access GUI...
0
1775
by: Salad | last post by:
My operating system is WinXP Pro. I have 1 gig of memory and the chip is an Intel Pentium 4. I am using Access97. A table has been supplied to me from an external source createdc from Visual FoxPro file, version 6.0. If I connect to it using File/GetExternalData/Link and select FoxPro as the file type and it links OK. I press Open and the table opens just like an Access table...quickly. There are 557 records. The problem is that...
6
11600
by: JimmyKoolPantz | last post by:
I have been given the task of converting a program from VFP (visual foxpro) to Visual Basic.net. My question is "Is it possible to generate a DBF file Dynamically(at runtime) using Visual Basic.Net?" With all the field properties, such as, field length and type. I'm not sure if this is a stupid quesiton or If I am just over looking something, but I have not found solid information on the internet about this topic. Any useful...
1
2015
by: cecilchamp | last post by:
I have already set up a Visual FoxPro Remote View to connect to an MS ACCESS Database, but I continually have an OPEN FILE Dialog Box pop up looking for the MS ACCESS MDB file that I had already pre-defined in a Visual FoxPro Connection. Why does this OPEN DIALOG Box keep coming up?
11
5096
by: Gwindor | last post by:
I have been doing programming in Access for about 10 years. I am now being asked to make an Access front end for data that is stored in SQL Server. My impression is that the only way to do this is to use a .adp application, rather than an .mdb file. Is that correct? Is it possible to use DAO or ADO with .adp objects? Also, is there a good manual on making access front ends for SQL
3
5169
by: HistoricVFP | last post by:
Hello, I’ve been given the task of importing .dbf files from a very old version of Visual FoxPro (version 2.1) into Access (2003). When I import the data straight to Access it errors with: External table is not in the expected format. (Error 3274) I’ve tried the following but it did not work: “To import data from a FoxPro database, use the Microsoft Visual FoxPro ODBC driver. To do so, follow these steps: 1. Click Start, and then...
0
8538
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8961
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8801
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7627
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6459
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4324
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4557
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2974
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2238
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.