SQL and API methods + benchs

[Olivier]

Le 24 janv. 05, à 10:59, Ruslan Zasukhin a écrit :

> 2 tables no way.
>
>     JOIN of several tables -- this is feature of SQL.
>
> For single table you can use Table.Sort()
>
>
> But explain me, what you want to sort in result ?

I have two tables :

One table with zip codes and cities.
A table with streets.
the two tables are binary-linked.

I make a search. For example I want to have all the streets of the 
country.
I have a listbox where I display all the streets of the country.
This listbox has three columns: zip, city, namestreet.
I shall want that this listbox is sorted out 1-by zip, 2-by city, 3-by 
street, so that the reading is easy.

33000 	 BORDEAUX 	street of Odessa
75001 	 PARIS 	 	street of Kiev
75001 	 PARIS 	 	street of Paradigma
75002 	 PARIS 	 	street of Youri Gagarine

I reports me that the API is useful only in some cases.
I wished to modify my project to use only the API in ALL my project. It 
was exciting.
I had begun to modify all my project for that.
But I made an error, I believe that I am rather going to use the 
Valentina' SQL and to use maybe the API that in certain cases.

For BINARY LINK, What are the advantages with regard to objectPtr?

thank you

olivier