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
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:[EMAIL PROTECTED] title:Yazilim Gelistirme Uzmani tel;work:+903122101490 tel;fax:+903122101492 x-mozilla-html:FALSE url:http://www.labristeknoloji.com version:2.1 end:vcard
