Re: Fw: Array Empty Slots

["M.Baris Demiray" <baris@labristeknoloji.com>]

[-- Attachment #1: Type: text/plain, Size: 1962 bytes --]


Hi Chris,

Chris wrote:
>  Thank you very much for your response.
>  The problem maybe is in the DBMS query.I am not a DBA guru but i cant find
>  until now an atomic operation (query ) that can handle this kind of
>  procedural algorithm.Do you have sth to suggest?

No, the algorithm is already in the DBMS. You should only SELECT the
records WHERE their values is empty. And that's what you need, array of
empty records. Take a look at the index hint in my previous reply.

>  Another problem is that in the next version of this application the C
>  interface will go away and the application will be a Web based one.This is
> a
>  bigger problem cause php is much slower in array searching operations.I
> have
>  looked a lot of bench's for this subject and i dont see positive results.>  Do you know or have sth to suggest for the web based operation? 

Sorry, neither i'm a web developer, nor this is the proper place to
discuss.

 > Its gone be
>  much more difficult to solve this problem because the bottleneck there,
>  should not concern only the computer but the language and the algorithm
>  also.Please if you have sth to suggest, can you include some source code
> for
>  benchmarking if its no trouble for you?

A basic benchmarking can be done with usual library functions and system
calls. For example, gettimeofday [1] system call can return milliseconds
sensitive and clock_gettime [2] function can return nanoseconds
sensitive time information. These sensitivity will be enough i think.

Write tiny array searching and database querying codes and get time
differences. These will give some idea.

Regards.

[1] man 2 gettimeofday
[2] man 3 clock_gettime

> 
>  Best regards,
>  Chris.

-- 
"You have to understand, most of these people are not ready to be
unplugged. And many of them are no inert, so hopelessly dependent
on the system, that they will fight to protect it."
                                                         Morpheus

[-- Attachment #2: baris.vcf --]
[-- Type: text/x-vcard, Size: 342 bytes --]

begin:vcard
fn:M.Baris Demiray
n:Demiray;M.Baris
org:Labris Teknoloji
adr:;;Teknokent Silikon Bina No:24 ODTU;Ankara;;06531;Turkey
email;internet:baris@labristeknoloji.com
title:Yazilim Gelistirme Uzmani
tel;work:+903122101490
tel;fax:+903122101492
x-mozilla-html:FALSE
url:http://www.labristeknoloji.com
version:2.1
end:vcard