ODBC link to DBF slowly

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

IT - 27 Feb 2004 08:11 GMT

Our system using VFP build up. If I have using ODBC link this system is very
slow, If i have using network share, the speed is fine. But I think using
ODBC better than network share. How can reslove the ODBC slove out the ODBC
problems.

Thanks
Jackie Wong

Reply to this Message

Stefan Wuebbe - 28 Feb 2004 10:00 GMT

Sounds as if the client app is written in FoxPro and runs
in a LAN with a file server keeping the FoxPro data files?
If so, it may be no big improvement to use ODBC, because
of the additional layer slowing things down.
If your concern is unstable (client) hardware, I'd suggest a
"real" Client/Server RDBMS backend, like DB2, MySql,
MS SqlServer, Oracle, PostgreSQL etc.

hth
-Stefan

> Our system using VFP build up. If I have using ODBC link this system is very
> slow, If i have using network share, the speed is fine. But I think using
[quoted text clipped - 3 lines]
> Thanks
> Jackie Wong

Reply to this Message

IT - 01 Mar 2004 02:45 GMT

Yes, you written is correct. The FoxPro data with keep on file server and
front end ( client) run FoxPro. But current the Foxpro data with share on
the LAN file server, is not secure. Any solution to improvment the access /
secure performent. Because curent I am not pay more license free in MS SQL
Server.

Thanks
Jackie Wong

> Sounds as if the client app is written in FoxPro and runs
> in a LAN with a file server keeping the FoxPro data files?
[quoted text clipped - 16 lines]
> > Thanks
> > Jackie Wong

Reply to this Message

Stefan Wuebbe - 01 Mar 2004 08:06 GMT

There are some "free" RDBMS', like Firebird, MaxDB (formerly
SAP DB), Microsoft MSDE, MySQL, PostgreSQL. All of them
offer ODBC interfaces which can be easily used from a Vfp middle
tier / frontend. I'd suggest to have a look at the last three first. See
also http://groups.google.com/advanced_group_search

-Stefan

> Yes, you written is correct. The FoxPro data with keep on file server and
> front end ( client) run FoxPro. But current the Foxpro data with share on
[quoted text clipped - 25 lines]
> > > Thanks
> > > Jackie Wong

Reply to this Message

IT - 01 Mar 2004 09:58 GMT

I cannot access to your advice web site, pleease re-post again.

Thanks
Jackie Wong

> There are some "free" RDBMS', like Firebird, MaxDB (formerly
> SAP DB), Microsoft MSDE, MySQL, PostgreSQL. All of them
[quoted text clipped - 35 lines]
> > > > Thanks
> > > > Jackie Wong

Reply to this Message

Stefan Wuebbe - 01 Mar 2004 11:16 GMT

> > also http://groups.google.com/advanced_group_search
>
> I cannot access to your advice web site, pleease re-post again.

It's the "advanced group search" of www.google.com , where
you can search archived messages of all public newsgroups.
Just tried the link and it timed-out first but worked then on
a second attempt for me.

-Stefan

Reply to this Message

IT - 02 Mar 2004 09:42 GMT

Hi , for your information, which tools should be better apply on our
enviorment , please advice.

Jackie

> > > also http://groups.google.com/advanced_group_search
> >
[quoted text clipped - 6 lines]
>
> -Stefan

Reply to this Message

Stefan Wuebbe - 02 Mar 2004 12:01 GMT

Hi,
They all have a lot of particular features and strong and weak
points. I'd rather suggest to scan the newsgroups / web for
your specification subjects.

Very approximately and from my point of view:
Firebird was made by Borland originally, so there is a lot of people
(e.g. Delphi programmers) using it.
MaxDB (maintained by MySQL AB now as well) is quite complex
but not complete yet, probably not exactly a "rapid application
development" tool.
Microsoft MSDE, aka SQLServer limited edition, same security
features, probably the closest to the focus of attention of the Fox
dev team. Size and number of simultaneous connections are limited
intentionally though.
MySQL is extremely popular, lots of documentation and support,
quite quick, but a lot of missing features yet.
PostgreSQL was an academic project originally, very complete,
therefor slower than MySQL in many scenarios.

hth
-Stefan

> Hi , for your information, which tools should be better apply on our
> enviorment , please advice.
[quoted text clipped - 11 lines]
> >
> > -Stefan

Reply to this Message