Hi Experts,
I have some queries, can you please clarify it.
1. I have created HTML form with textbox, text area, radio button,
check box, dropdown box.
How to get form name
and form element names (textbox, text area, radio button, check box, dropdown
box) in JavaScript dynamically.
2. I am using persistent connection (mysql_pconnect ()) for
connecting database.
User A is browsing
my website. Now User B and C browsing my website.
What happens here B
and C are using same connection or creating new connection for each user?
If B and C use
same connection, is there any queue concept for allocating resources?
3. SELECT * FROM `emp` where ename In(select ename from emp
group by ename having count(ename)>1).
I have 1000 records in EMP table. For executing above query
it takes milliseconds.
I have 10Lacs records in EMP table. For executing above
query it takes so much time.
How can I reduce that time?
How can i calculate query performance level in MySQL?
4. I have products table with field’s product id and product
name.
I have 1000 records in products table. But 100 product names
are wrong. For that, I am uploading new excel file and comparing excel product id
and products table product id.
If it matches, I am updating that product name.
For the above process, I am using for loop, Select query and
Update query. For 1000 records for loop is working fine.
What about, if products table have 10Lacs records and 1Lac
product names are wrong.
Is for loop working?
If not what is the solution for executing 10Lacs records?
Thanks,
Gangadhara Prasad
Unlimited freedom, unlimited storage. Get it now, on http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/
[Non-text portions of this message have been removed]
