FiveTech Software tech support forums

Adolfo, Marcelo is right about the index loading. If the index is complex it could be similar in size to a recordset containing only a few fields. However, if the index contains only one field and the recordset contains lots of fields, (which is more typical) the index would be much smaller. We will...

Marcelo... That's the idea... Measure the traffic in both situations, DBF's and ADO with similar Tables, size, n° of records and fields. I Will put times, and number of bytes transmited and received in both cases. I made early tests with NETWORK PROBE 3.0 a very reliable network tool, freeware. and ...

Adolfo, I don't sure about the test, because SAMBA works like a file server then, it's different to a Database server, I think when you open a DBF with index, the index will load in memory and you will see in the network traffic, this is defferent when use DATABASE SERVER (MySQL, Postgres, ADS, etc)...

James... I'll will measure data traffic (from opening the DBF til the browse is completely full ), then each keystroke till the record is found, using incremental search, then the same for ADO. I'll will record times, and bytes received and transmited to the ports related to each case, 3306 when MYS...

Adolfo, DBF, SQL, DBF plus index, SQL plus index.. would be nice to know how the use of an index will affect the traffic... don't you think so ? I'm not sure what you are testing for. You cannot do an incremental search without an index. I do not know exactly how a recordset is searched--I am guessi...

Adolfo wrote:There will be 4 tests..

DBF, SQL, DBF plus index, SQL plus index.. would be nice to know how the use of an index will affect the traffic... don't you think so ?

Yes.

EMG

Adolfo; Please, also compare speed. Go to the bottom of the list by pressing Cntrl-End, then press and keep pressed the uparrow key for a while. Watch the records scroll. After a while, Go to the top, do the same in the opposite direction. Then try incremental search. Also, please test both using a ...

Enrico...

There will be 4 tests..

DBF, SQL, DBF plus index, SQL plus index.. would be nice to know how the use of an index will affect the traffic... don't you think so ?

From Chile
Adolfo

Sounds interesting. Thank you, Adolfo.

EMG

James.. Enrico I'm preparing a test with a Network Traffic tool we have here, in order to analyze the traffic in both cases, a browse of a dbf with 300.00 records and a Mysql Table of the same size. My problem is trying to isolate only the traffic for both cases, port 3306 is completely checked, but...

Yes, thank you. You are right.

EMG

Enrico, >I don't understand. If I'm not missing something, 3-keys indexed incremental searching should requires the read of a maximum of 3 records I am also considering the browse showing 10 records. So the first keystroke uses the index to find the first match, then that record is displayed as t...

I don't understand. If I'm not missing something, 3-keys indexed incremental searching should requires the read of a maximum of 3 records, plus the read of the index tree, of course. Or am I wrong?

EMG

Enrico, >Why 30? It seems to me that the number of records to read depends on the actual data. Upon rethinking this it would actually be 40 counting the first display of records before the first keystroke. So the first display is 10 records. After the first keystroke you jump to the first record ...

James Bott wrote:With the DBF browse finding the record in 3 keystrokes, you have to read (at most) 30 records x 100 fields or 3000 fields.

Why 30? It seems to me that the number of records to read depends on the actual data.

EMG