CODEWITHSUNDEEP
databasefoxprodbf
user2418596
user2418596

Reputation:

DBF/Foxpro - super slow queries through the network

I have an app that conducts queries on multiple DBF files over local area network.

However, the queries are extremely slow (up to 5 minutes on some files). They work quite fast locally, but since this app is going to be distributed to several customers we must account for those who have their DBFs in a remote machine.

What can I do to speed up these queries? I've already turned off oplocks, I repacked the DBFs, there's no antivirus running, and the issue persists.

Upvotes: 0

Views: 864

Answers (1)

Alan B
Alan B

Reputation: 4288

You don't say what version of FoxPro you're using, or what client and server operating systems are involved, or what sort of network connection is involved.

On up to date Server 2008 R2 or later, with up to date Windows 7 SP1 or later clients you do not need to (and indeed should not) mess with OpLocks. In fact, you can't turn them off anyway without forcing the server back to SMB1, and you really don't want to do that.

The absolute first thing you should do before messing with anything infrastructural is make sure all your queries are Rushmore optimised because as with any database you need to take advantage of indexes. Have you done that?

Upvotes: 1

Related Questions