dbfs on Network : wich performance method?

Posts: 7317

Joined: Thu Oct 18, 2012 07:17 PM

Re: dbfs on Network : wich performance method?
Posted: Wed Oct 31, 2018 01:47 PM

Enrico Maria Giordano wrote:Can you send me the DBF and the CDX to reproduce the problem here, please?

EMG

SENT

Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)

I use : FiveWin for Harbour March-April 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com

Enrico Maria Giordano

Posts: 9020

Joined: Thu Oct 06, 2005 08:17 PM

Re: dbfs on Network : wich performance method?
Posted: Wed Oct 31, 2018 02:00 PM

Ok, thank you. As you can check for yourself, the CDX contains a tag with "id" key. So it's just a corrupted CDX. Please delete it, rebuild it and let me know.

EMG

Enrico Maria Giordano

e.m.giordano@emagsoftware.it
http://www.emagsoftware.it
http://www.emagsoftware.it/emgmusic
http://www.emagsoftware.it/spectrum
http://www.emagsoftware.it/tbosg

Silvio.Falconi

Posts: 7317

Joined: Thu Oct 18, 2012 07:17 PM

Re: dbfs on Network : wich performance method?
Posted: Fri Nov 02, 2018 10:34 AM

I erase the cdx.
then I run the test made from James
it create the cdx
then open emagdbu , open customer database
Open the cdx and set the tag id
the same

Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)

I use : FiveWin for Harbour March-April 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com

Enrico Maria Giordano

Posts: 9020

Joined: Thu Oct 06, 2005 08:17 PM

Re: dbfs on Network : wich performance method?
Posted: Fri Nov 02, 2018 10:54 AM

The example from James is not valid for your customer.dbf because it builds the wrong tag:

Code (fw): Select all Collapse

Index on "id" tag "custno" to customer

Your customer.dbf doesn't have a field named "id".

EMG

Enrico Maria Giordano

e.m.giordano@emagsoftware.it
http://www.emagsoftware.it
http://www.emagsoftware.it/emgmusic
http://www.emagsoftware.it/spectrum
http://www.emagsoftware.it/tbosg

Silvio.Falconi

Posts: 7317

Joined: Thu Oct 18, 2012 07:17 PM

Re: dbfs on Network : wich performance method?
Posted: Fri Nov 02, 2018 11:22 AM

yes of cource but...

why the code ( test.prg) compiled create the cdx if is not valid ?
we Know it's is not valid but the exe crete the cdx

Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)

I use : FiveWin for Harbour March-April 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com

Enrico Maria Giordano

Posts: 9020

Joined: Thu Oct 06, 2005 08:17 PM

Re: dbfs on Network : wich performance method?
Posted: Fri Nov 02, 2018 12:22 PM

I don't know, sorry.

EMG

Enrico Maria Giordano

e.m.giordano@emagsoftware.it
http://www.emagsoftware.it
http://www.emagsoftware.it/emgmusic
http://www.emagsoftware.it/spectrum
http://www.emagsoftware.it/tbosg

James Bott

Posts: 4840

Joined: Fri Nov 18, 2005 04:52 PM

Re: dbfs on Network : wich performance method?
Posted: Fri Nov 02, 2018 03:13 PM

Sorry if I sent the wrong customer file. It is disconcerting that the CDX was created without any error message. That would be hard to track down as we have just seen.

Silvio, were you able to get the sample to run now?

James

FWH 18.05/xHarbour 1.2.3/BCC7/Windows 10

Silvio.Falconi

Posts: 7317

Joined: Thu Oct 18, 2012 07:17 PM

Re: dbfs on Network : wich performance method?
Posted: Fri Nov 02, 2018 04:30 PM

James,

I wanted understand why the command :

Code (fw): Select all Collapse

Index on "id" tag "custno" to customer

create the cdx and not make error

It seem we can index any field not exist into a dbf ...

Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)

I use : FiveWin for Harbour March-April 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com

Enrico Maria Giordano

Posts: 9020

Joined: Thu Oct 06, 2005 08:17 PM

Re: dbfs on Network : wich performance method?
Posted: Fri Nov 02, 2018 04:35 PM

I just realized that this syntax is uncorrect:

Code (fw): Select all Collapse

Index on "id" tag "custno" to customer

The correct one is:

Code (fw): Select all Collapse

Index on id tag "custno" to customer

Or, even better:

Code (fw): Select all Collapse

Index on FIELD -> id tag "custno" to customer

EMG

Enrico Maria Giordano

e.m.giordano@emagsoftware.it
http://www.emagsoftware.it
http://www.emagsoftware.it/emgmusic
http://www.emagsoftware.it/spectrum
http://www.emagsoftware.it/tbosg

James Bott

Posts: 4840

Joined: Fri Nov 18, 2005 04:52 PM

Re: dbfs on Network : wich performance method?
Posted: Fri Nov 02, 2018 04:48 PM

Enrico,

Thanks for finding that.

I did a search of all my source and I did find a couple of other times I used quotes. It would be nice if this generated an error. I must have been going nuts trying to figure out why those indexes weren't working.

Enrico, would this be a (x)Harbour issue. If so, would you mind reporting it?

James

FWH 18.05/xHarbour 1.2.3/BCC7/Windows 10

Enrico Maria Giordano

Posts: 9020

Joined: Thu Oct 06, 2005 08:17 PM

Re: dbfs on Network : wich performance method?
Posted: Fri Nov 02, 2018 05:04 PM

This is not a bug. Is perfectly legal to build an index on a constant key:

Code (fw): Select all Collapse