dartsuresh
msg:4421227 | 6:58 am on Feb 24, 2012 (gmt 0) |
am explain more
for example we have 2 database first one have detail of all domain name and subdomian name owner and so this is referenced database another one is used to save the search result of user. we have a php page when user enter the some domain name domain1.com and click search then php page call perl script with system(""perl /opt/disco/crawlr.pl -v -d $domain $userid > /dev/null &"");. perl script search the data about this domian1.com name from database1 then insert into detail to database2 with search key and userid and domain name subdomain name and so.this script working well when only one user search at a time.when 2 user search 1 user using domain1.com and 2 user using domain2.com then perl script search the detail from database1 and insert into database 2 but problem is result is mixed between 2 user i mean we have a coloumn name domain,userid actual result is domain |userid domain1.com |1 sub1.domain1.com|1 sub2.domain1.com|2 domain2 |2 sub1.domain2.com|2 sub2.domain2.com|2 but my result domain |userid domain1.com |1 sub1.domain1.com|2 sub2.domain1.com|1 domain2 |2 sub1.domain2.com|1 sub2.domain2.com|2 i thing this is clear"
|
chorny
msg:4422008 | 8:59 pm on Feb 26, 2012 (gmt 0) |
Please write more clearly next time.
What is the name of mysql table?
|
phranque
msg:4424471 | 1:29 pm on Mar 3, 2012 (gmt 0) |
welcome to WebmasterWorld, dartsuresh!
from your description it is impossible to tell if this is a perl problem or a database concurrency problem.
what type of database do you have?
are you using mod_perl on your server?
what methods have you tried while debugging the problem?
|
|
