SQL and API methods + benchs
Ruslan Zasukhin
sunshine at public.kherson.ua
Mon Jan 24 10:12:21 CST 2005
On 1/24/05 7:44 AM, "Olivier" <vidal_olivier at yahoo.fr> wrote:
> 1 -
>
> 100 streets arre linked (with binarylink) with 1 zipcode '75000'.
>
> WITH SELECT zipcode, cityname,namestreet FROM zipcity join street on
> linkcitystreet where zipcode='75000' ORDER BY zipcode, cityname, namestreet
>
> first search : 3 or 4 ticks
> next searchs : 1 ticks, sometimes 2.
>
> WITH EQUIVALENT API and Sets
>
> first search : 8 ticks
> next searchs : 6 or 7 ticks
You have sent me code on this so I will do testing self ?
--
Best regards,
Ruslan Zasukhin [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com
To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------
More information about the Valentina-beta
mailing list