Tim


For some reason this went through my mind while walking the dog this morning, and I'm baffled.

From your help file for CHAR

<<the value being assigned will be padded with spaces to the specified length>>

Then we have VARCHAR where trailing spaces can be entered, and stored, but not used for comparison?

So for CHAR there's no point in NOT comparing spaces if its faster, and for VARCHAR if you don't allow in a compare what's the point in storing, and would not storing make things faster?

If inserts/amends would be slower but SELECT's/comparison would be faster remember I'm a WORM.

Roy Lambert

Felix,

<< Sure, both DBISAM and EDB tables are sent. >>

Waiting on the table password.  However, the issue might simply be down to
the fact that EDB is generating an encrypted result set by default because
the source table(s) are encrypted, whereas DBISAM required that you specify
the ENCRYPTED WITH clause.

--
Tim Young
Elevate Software
www.elevatesoft.com

Dave,

<< Then why is the second time the DBISAM query is executed so much faster
than the second time the EDB query is executed? In other words, the DBISAM
query speed improves dramatically the second time it is run compared to a
small improvement with EDB? >>

I don't know, but there isn't anything in either product that is
specifically doing something with the Windows file system cache.

--
Tim Young
Elevate Software
www.elevatesoft.com

Roy,

<< So for CHAR there's no point in NOT comparing spaces if its faster, >>

It's not faster.

<< and for VARCHAR if you don't allow in a compare what's the point in
storing, and would not storing make things faster? >>

Because the data needs to be retained as it was originally entered.  Only
for comparison purposes do the spaces get ignored.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim, you are absolutely right: I removed the encryption and the same query needed only
0.06 sec.!! That means it is much faster than DBISAM, but only without encryption.

Interesting to know. You should perhaps mention that in the manuals.

Thanks and regards. Uli