Hi:

Please they excuse my English.

A basic consultation:

I have designed my data base with two tables (very important) with
primary keys to "char".

That way it listens that the data bases better work with primary keys to
"integer".

I am making some tests of comparison for the recording and access to
tables with keys "to char" and another one with key "to integer"

Example: to char = ' 00000000010000 '
to integer = 1

In my tests the recording in the table with key "to integer" is double
the fastest one than with the key table "to char".

It costs to me to determine if with the "select" happens something to
similiar.

Reason why my consultations are the following ones:

a) The "Select" are also faster in tables with keys "to integer" that
with keys "to char"?

b) Really exists as much difference of performance between tables with
keys "to char" and tables with key "to integer"?

c) That it says the theory, that they recommend to me to use? I consult
to them then as I already said to them designs everything with 2 tables
(very important) with primary keys "to char" and if really the
performance is extremely superior with keys "to integer" I believe that
I must make the decision to change, which will consume long time to me
(the development of the program this in 70 %), reason why need to be
really safe of the situation.

Thank you very much

Edgar Brítez
Sebaot Software
Asunción-Paraguay