DBF/CDX or SQL

Re: DBF/CDX or SQL

Postby Enrico Maria Giordano » Sat Oct 24, 2009 4:14 pm

Believe me: a faulty network card can cause unexpected results.

EMG
User avatar
Enrico Maria Giordano
 
Posts: 8701
Joined: Thu Oct 06, 2005 8:17 pm
Location: Roma - Italia

Re: DBF/CDX or SQL

Postby James Bott » Sat Oct 24, 2009 6:09 pm

Marc,

>It's the same for antivirus-program becauwe it's running fast on the network/server when only one person is using it..

I was not saying that AV was the reason--I was just reporting the setup of my test system.

There still must be some other difference in your system since it works fine for both me and Otto.

Can you test on a different network? Or, using different PC's on the same network?

James
User avatar
James Bott
 
Posts: 4840
Joined: Fri Nov 18, 2005 4:52 pm
Location: San Diego, California, USA

Re: DBF/CDX or SQL

Postby Marc Vanzegbroeck » Sat Oct 24, 2009 9:19 pm

James,

I will test it on other PC's on the network and also on another network.
Did you thy it with the exe-files that I have compiled?

Thanks,
Marc
Regards,
Marc

FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
Marc Vanzegbroeck
 
Posts: 1159
Joined: Mon Oct 17, 2005 5:41 am
Location: Belgium

Re: DBF/CDX or SQL

Postby James Bott » Mon Oct 26, 2009 3:54 am

Marc,

>Did you thy it with the exe-files that I have compiled?

Did you email me some EXE files? If so, I didn't get them. Please try again.

jbott at compuserve dot com

I did my tests by compiling the source code that you posted.

James
User avatar
James Bott
 
Posts: 4840
Joined: Fri Nov 18, 2005 4:52 pm
Location: San Diego, California, USA

Re: DBF/CDX or SQL

Postby Marc Vanzegbroeck » Mon Oct 26, 2009 6:16 am

James,

There are 2 links to the exe-files in this topic a couple of messages ago.

In the mean time I tried it on an other network an the result was 0.06sec without test, and 1.02 with running test.exe.

Its much faster, but still 10 times slower then running without test.exe

Regards,
Marc
Regards,
Marc

FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
Marc Vanzegbroeck
 
Posts: 1159
Joined: Mon Oct 17, 2005 5:41 am
Location: Belgium

Re: DBF/CDX or SQL

Postby James Bott » Mon Oct 26, 2009 12:24 pm

Marc,

I retested using your EXEs and I get 0.047 seconds both with and without test.exe running on another PC.

What version of Windows are you running on your networks?

James
User avatar
James Bott
 
Posts: 4840
Joined: Fri Nov 18, 2005 4:52 pm
Location: San Diego, California, USA

Re: DBF/CDX or SQL

Postby reinaldocrespo » Mon Oct 26, 2009 3:07 pm

Marc;

It's not dbfcdx rdd. You need to look elsewhere. Having said that; why not try another compatible dbfcdx rdd? (ADS comes to mind).
RDDSetDefault( "ADS" )
AdsSetFileType( ADS_CDX )

No SQL is faster performing sequential operations they way you are on your sample. The only thing that could be faster would be using ADS on client-server mode (called REMOTE).

If your are running a peer-to-peer network then I would not discard EMG's suggestion. it might be a good idea to "sniff" the packets going in-out of the pc. See what kind of network traffic is going on.

If the files are shared, then when "replacing" you must lock the record. Therefore; there IS locking involved. Without ADS (on proprietary locking mode), locking is done by the OS. So, we can't discard record locking problems either.

The problem you describe sounds intriguing. I've never experienced it. Not even with very many users. I'd like to learn what finally solved the problem. Please keep us informed.

Regards,



Reinaldo.
User avatar
reinaldocrespo
 
Posts: 979
Joined: Thu Nov 17, 2005 5:49 pm
Location: Fort Lauderdale, FL

Re: DBF/CDX or SQL

Postby James Bott » Mon Oct 26, 2009 3:34 pm

Marc,

I would just like to clarify exactly how you are running the test.

I am running a peer-to-peer network. For easy reference I am going to call one PC the server (where the files are) and the other PC the client.

Tests
1. Server: Run Test1.exe = 0.047 sec
2. Client: run test.exe, server: run test1.exe = 0.047 secs
3. Server - run Test.exe, Client: run test1.exe = 0.14 to 0.61 secs

Note that Test1.exe will always run slower on the client PC than on the server PC because it has to read indexes and records across the network.

Please tell us exactly which tests you are running.

James
Last edited by James Bott on Mon Oct 26, 2009 7:34 pm, edited 1 time in total.
User avatar
James Bott
 
Posts: 4840
Joined: Fri Nov 18, 2005 4:52 pm
Location: San Diego, California, USA

Re: DBF/CDX or SQL

Postby Marc Vanzegbroeck » Mon Oct 26, 2009 6:11 pm

James,

The programs test and test1 are installed on the HD of the server.
I run test1.exe from a PC connected to the network , and test.exe from another PC.

Regards,
Marc
Regards,
Marc

FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
Marc Vanzegbroeck
 
Posts: 1159
Joined: Mon Oct 17, 2005 5:41 am
Location: Belgium

Re: DBF/CDX or SQL

Postby James Bott » Mon Oct 26, 2009 8:15 pm

Marc,

OK, I didn't know you were using 3 PCs.

I have replicated your test using your EXEs on two client PCs and I get a similar result running Test1.exe-- from 4-6 seconds.

However, I don't think we can contribute this to the CDX index yet. Perhaps it would be worthwhile to run some other DBF test without using an index like skipping through a couple of hundred records.

I also wonder if your test is a real-world condition. I can't think of any time I ever needed to do a seek of 1000 records at a time; I can't even remember ever needing to seek more than one record at a time. Do you have an application that does seek lots of records like that?

My point is that even if seeking takes 10 times longer when two client PCs have the app open, does it really matter when only one seek is being done at a time? If it takes 0.6 seconds instead of 0.06 seconds, I doubt that any user is going to really notice.

James
User avatar
James Bott
 
Posts: 4840
Joined: Fri Nov 18, 2005 4:52 pm
Location: San Diego, California, USA

Re: DBF/CDX or SQL

Postby Alfredo Arteaga » Mon Oct 26, 2009 9:04 pm

Marc.

Test: ipconfig /release before run.
User avatar
Alfredo Arteaga
 
Posts: 326
Joined: Sun Oct 09, 2005 5:22 pm
Location: Mexico

Re: DBF/CDX or SQL

Postby joseluispalma » Sat Mar 12, 2016 10:43 am

Hello Mark,

I am just experiencing this problem you had with 2 or more users.

How did you solve it?.

Thank you very much!.
joseluispalma
 
Posts: 109
Joined: Mon Apr 30, 2012 9:10 am

Re: DBF/CDX or SQL

Postby Marc Vanzegbroeck » Sat Mar 12, 2016 3:22 pm

Hi,

The people of the network changed something.
I don't remember anymore what it was, since it's more than 6 years ago.
A couple of years ago, I moved the program to SQL, and now it's very fast
Regards,
Marc

FWH32+xHarbour | FWH64+Harbour | BCC | DBF | ADO+MySQL | ADO+MariaDB | ADO+SQLite
Marc Vanzegbroeck
 
Posts: 1159
Joined: Mon Oct 17, 2005 5:41 am
Location: Belgium

Re: DBF/CDX or SQL

Postby joseluispalma » Sun Mar 13, 2016 8:52 am

Hello Mark,

I really will apreciate if you could provide us the changes in the network.

OS_NetRegOK( .t.) does not fix it.

With only one PC using the software, it´s fine. Databases are quite small. All wired with 100 Mbps.

Thank you.
joseluispalma
 
Posts: 109
Joined: Mon Apr 30, 2012 9:10 am

Previous

Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 44 guests