Hi,

For 2 lakh records, this works well but when the total number of queries is more than 5 lakh it does not . Actually i have 64 lakh records to work with and this gets forever.
UPDATE...

Hi Shanti,

Thanks for the reply but I needed an advance logic for my script was in need of an alternative with temporary tables and the total record set to play with was 64 lakh...

hi experts,

Is it possible that i could get the 3 queries made into one single query.Any help could make me understand and correct myelf in better queries. Each query is taking long time and...

Yeah, it seems like innodb buffer memory increase configuration and power failure amidst import did the cheat. NOw again got a new server up.

Thanks buddy for concern.

I think, linux on boot up tries to recover the crash but fails. I added safe mode to my.cnf and still, it starts and ends quickly. Finally, Ystrday evening , fed up, I kicked myself for a fresh...

Hi,

I wanted to make use of a algorithm script for computing scores nd though i started doing it with a single database, i after testing script, decided to get a master and score databases...

Hi dickersonka,

Thanks for the time and reply. But still, wouldnt there be any alternative approach i could take..

Hi to xperts here,

I do not know how to update with the follwing requirement
$score_update_query = "UPDATE participation_score SET score_last_update = '$date' , score =...

Hi ,

Wishes!

I am doing a iterative calculation and in the last iteration, i update few of my tables. What i am trying to do is , make this update more perfect.

Is...

I had written a algorithm, that gets executed daily. it does the following.

Make use of 4 auxillary tables , A,B,C,D. Reads from the other database tables, using few rates and updates or populates...

hi,

I got a daily task script that does the job as below:

#1. Calculate score for one time, count and rank using 4 auxillary empty tables, using data from few other main tables.
...

Hi ,

I have got a dump sql file from the remote db server and the concern is that i am new to the design which involves the triggers and all.

When i tried to set up a environment...

Hi,

Need in brief:

Have 3 tables. I need to extract data from two tables and fill the third table.

Table structure:
COM PROFILER:

CREATE TABLE comprofiler (

Hi to all,

I would like to build a registration module and this registrastion module has the following requirements.

It is mainly divided in to four parts.
1.General Info
...

hi,

I have started programming (learning) to free myself from depencies.I do not know how to do the below.

i made a form that has a input box for emai and two passord inputboxexs.on submit...

sorry..for mixing two seperate issues...
1.The earlier problem was solved.
2.the private message is to get from you tip regarding how to test my application from a remote system...

how to...

hi,
thanks for the reply,but it worked the way i had done...

well I am inside a network(LAN) and my system has the application server running and database server running....(time being).

...

hi,

please anyone help me with this.I have a database 'hbm' which contain a table called hitted having 2 columns(id,hit).

I inserted a record with id=1.

Now i need to query this database.
...