vts31
10-22 04:17 PM
i always start a drawing or anything, with primitives. Usually circles and curves because they are organik..if i want something more rigid i uses cubes...then i try to visualize that primitives potential and how i can link it to something else alter in the composition...after i do that 1 of 2 things happen, I either do it or i get scared ima ruin it and just go work on something else.
wallpaper taylor swift with angs and straight. taylor swift with straight hair angs.
mirage
03-06 02:18 PM
I'm from PA... I had called Senator Specter's Office earlier last week, today I called up Senator Robert Casey's office...
You called office of which Senators?
You called office of which Senators?
tnite
09-27 09:36 AM
Even i got the Section: UNKNOWN thing from NSC. My 140 approved on MAY 2007, But online case status is still showing case pending, Is it because of this?
Just to add to the pile, Mine says "UNKNOWN".
So what? Move on guys and if you're still worried take it with you to FP and ask the IO
Just to add to the pile, Mine says "UNKNOWN".
So what? Move on guys and if you're still worried take it with you to FP and ask the IO
2011 Taylor Swift emphasizes her
BharatPremi
11-24 12:33 PM
Also include some text which says that you were an fulltime employee (40 hrs per week)...
Assuming original poster from India, definition of Full Time Employment is 48 hours of work per week in private sector and 44 hours of work in most public sector. Many people make mistake on this ( Completely forgetting how they slogged...:)). 5 years back one of my friend got an RFE on this... Lawyer, through his internal sources came to know that INS had problem with the note regarding 40 hours of week as they knew in India, generally Public sector remained open for 44 hours. My friend was public sector employee in India.
Assuming original poster from India, definition of Full Time Employment is 48 hours of work per week in private sector and 44 hours of work in most public sector. Many people make mistake on this ( Completely forgetting how they slogged...:)). 5 years back one of my friend got an RFE on this... Lawyer, through his internal sources came to know that INS had problem with the note regarding 40 hours of week as they knew in India, generally Public sector remained open for 44 hours. My friend was public sector employee in India.
more...
pappu
02-04 10:23 PM
Great Idea. Good luck to AZ members. This will help form the AZ IV Chapter for future activities.
Dipika
11-25 12:43 PM
Hi, is anyone planning for H1b stamping at Tijuana mexico on 30th November. If so, please contact and we shall plan together. I am in LA area. Thanks!
Did you last stamped in Tijuana? Because Rule is just changed.
NEW RULE:
http://www..com/experience/readentries.do?category=22
You can have H1B stamping in Tijuana, only if you had last stamped in Tijuana.
Did you last stamped in Tijuana? Because Rule is just changed.
NEW RULE:
http://www..com/experience/readentries.do?category=22
You can have H1B stamping in Tijuana, only if you had last stamped in Tijuana.
more...
ramaa
06-21 01:05 PM
I have Old EB3 Labor and I-140 approved with PD 2003. I changed my employer and ready to file I-140, would like to port the PD from my old I-140. Could you tell me what steps I need to take care so that porting will be done by USCIS. Job Titles do not match, however description and salary are same.
Thanking you in advance.
Thanking you in advance.
2010 Taylor+swift+straight+hair
Uncertain
04-15 02:34 PM
I am in.
What do I need to do apart from contributions and convincing other friends to vote on the above thread?
What do I need to do apart from contributions and convincing other friends to vote on the above thread?
more...
Kumbakonam
11-30 11:55 AM
As the IO officers explained to you, instead of approving some other document(s), USCIS wrongly approved your I-485 application.
Regards
K
Regards
K
hair taylor swift with angs and
prinive
07-17 06:52 PM
Nop
Another silly question.
Do I file again? My packet reached USCIS on July 2nd. It was not returned.
Another silly question.
Do I file again? My packet reached USCIS on July 2nd. It was not returned.
more...
tikka
08-06 09:48 AM
...bump...
I will be there..
I will be there..
hot Taylor Swift#39;s Fringe Benefits
psaxena
07-31 01:45 PM
Hey INSBABY,
Please do not write such post, I was about to get a heart attack, you would have been responsible for my "Om namah swaha". Well would be good for the others in the line as one less in the line then :p
Dream:
EB3 I - OCT 2004 - CURRENT (Long long ago.../Once upon a time...)
Happened:
EB3 I - OCT 2005 - 01/JAN/98
EB3 I - OCT 2006 - 22/APR/01
EB3 I - OCT 2007 - 22/APR/01
EB3 I - OCT 2008 - 01/JUL/01
Expected:
EB3 I - OCT 2009 - 01/JAN/98
EB3 I - OCT 2010 - 22/APR/01
EB3 I - OCT 2011 - 22/APR/01
EB3 I - OCT 2012 - 01/JUL/01
EB3 I - OCT 2013 - 01/JAN/98
EB3 I - OCT 2014 - 22/APR/01
EB3 I - OCT 2015 - 22/APR/01
EB3 I - OCT 2016 - 01/JUL/01
EB3 I - OCT 2017 - 01/JAN/98
EB3 I - OCT 2018 - 22/APR/01
EB3 I - OCT 2019 - 22/APR/01
EB3 I - OCT 2020 - 01/JUL/01
Please do not write such post, I was about to get a heart attack, you would have been responsible for my "Om namah swaha". Well would be good for the others in the line as one less in the line then :p
Dream:
EB3 I - OCT 2004 - CURRENT (Long long ago.../Once upon a time...)
Happened:
EB3 I - OCT 2005 - 01/JAN/98
EB3 I - OCT 2006 - 22/APR/01
EB3 I - OCT 2007 - 22/APR/01
EB3 I - OCT 2008 - 01/JUL/01
Expected:
EB3 I - OCT 2009 - 01/JAN/98
EB3 I - OCT 2010 - 22/APR/01
EB3 I - OCT 2011 - 22/APR/01
EB3 I - OCT 2012 - 01/JUL/01
EB3 I - OCT 2013 - 01/JAN/98
EB3 I - OCT 2014 - 22/APR/01
EB3 I - OCT 2015 - 22/APR/01
EB3 I - OCT 2016 - 01/JUL/01
EB3 I - OCT 2017 - 01/JAN/98
EB3 I - OCT 2018 - 22/APR/01
EB3 I - OCT 2019 - 22/APR/01
EB3 I - OCT 2020 - 01/JUL/01
more...
house This Year, Taylor Swift
mihird
05-21 10:49 PM
I think, the PD should reset to the day the substition is done and not to the day the original labor was filed...otherwise it is unfair by all means..
But, I agree, we have bigger fish to fry...labor substitions probably only account for 1-5% of all cases...
I don't see any solution to visa retrogression...its just a way to control the number of people immigrating in...and if more people intend to immigrate from certain countries, their applications are bound to be backlogged...
Most of the current immigration debate is centered around illegal aliens and it has all to do with the Hispanic vote etc.
The only solace we can have is that if they do decide to grant amnesty to certain illegals, either they will be put behind the queue of legals, or we legals will first be pushed forward and then visa numbers made available to the illegals..
If illegals get priority in the visa number allocation, there will be plenty of uproar and finger pointing....I don't think the current administration would be able to pull something like that off..and in all insanity, if they do something like that, I will be the first one to join that queue of illegals :-)
But, I agree, we have bigger fish to fry...labor substitions probably only account for 1-5% of all cases...
I don't see any solution to visa retrogression...its just a way to control the number of people immigrating in...and if more people intend to immigrate from certain countries, their applications are bound to be backlogged...
Most of the current immigration debate is centered around illegal aliens and it has all to do with the Hispanic vote etc.
The only solace we can have is that if they do decide to grant amnesty to certain illegals, either they will be put behind the queue of legals, or we legals will first be pushed forward and then visa numbers made available to the illegals..
If illegals get priority in the visa number allocation, there will be plenty of uproar and finger pointing....I don't think the current administration would be able to pull something like that off..and in all insanity, if they do something like that, I will be the first one to join that queue of illegals :-)
tattoo makeup PHOTO: See Taylor Swift With taylor swift with straight hair bangs.
kilubilu46
08-06 10:07 AM
Could not attend the coffee appt. Hopefully will be able to attend the lunch.
more...
pictures Country singer Taylor Swift,
learning01
04-12 12:33 PM
As I had already posted in the news article thread (http://immigrationvoice.org/forum/showpost.php?p=8552&postcount=225), this is an exhaustive article with a bold and thought provoking headlines. The article can be accessed here - http://www.newsobserver.com/104/story/427793.html
Many skilled foreigners leaving U.S.
Exodus rooted in backlog for permanent status
Karin Rives, Staff Writer
When the Senate immigration bill fell apart last week, it did more than stymie efforts to deal with illegal immigration.
It derailed efforts to deal with an equally vexing business concern: a backlog in applications for so-called green cards, the coveted cards that are actually pink or white and that offer proof of lawful permanent residency.
Many people now wait six years or longer for the card. There are 526,000 applications pending, according to Immigration Voice, an advocacy group that tracks government data.
Lately, this has prompted an exodus of foreign workers who tired of waiting, to return home or go further afield. With the economies in Asia and elsewhere on the rise, they can easily find work in the native countries or in third nations that are more generous with their visas.
"You have China, Russia, India -- a lot of countries where you can go and make a lot of money. That's the biggest thing that has changed," said Murali Bashyam, a Raleigh immigration lawyer who helps companies sponsor immigrants. "Before, people were willing to wait it out. Now they can do just as well going back home, and they do."
Mike Plueddeman said he lost three employees (one a senior programmer with a doctorate) at Durham-based DynPro in the past two years because they tired of waiting for their green cards.
All three found good jobs in their home countries within a few weeks of leaving Durham, said Plueddeman, the software consultancy's human resource director.
"We are talking about very well-educated and highly skilled people who have been in the labor force a long time," he said. "You hate losing them."
This budding brain drain comes as the first American baby boomers retire and projections show a huge need for such professionals in the years ahead. U.S. universities graduate about 70,000 information technology students annually. Many people say that number won't meet the need for a projected 600,000 additional openings for information systems professionals between 2002 and 2012, and the openings made by retirements.
"We just don't have the pipeline right now," said Joe Freddoso, director of Cisco Systems' Research Triangle Park operations. "We are concerned there's going to be a shortage, and we're already seeing that in some areas."
Cisco has advertised an opening for a data-security specialist in Atlanta for several months, unable to find the right candidate. Freddoso believes the problem will spread unless the government allows more foreign workers to enter the country, and expedites their residency process.
However, not everybody believes in the labor shortage that corporations fret about.
Critics say that proposals to allow more skilled workers into the country would only depress wages and displace American-born workers who have yet to fully recover from the dot-com bust.
"We should only issue work-related visas if we really need them," said Caroline Espinosa, a spokeswoman with NumbersUSA, a Washington, D.C., group pushing for immigration reduction. "There are 2.5 million native born American workers in the math and computer field who are currently out of work. It begs the question whether we truly need foreign workers."
She added that the immigration backlog would be aggravated by raising the cap for temporary and permanent visas, which would make it harder for those who deserve to immigrate to do so.
Waiting since 2003
Sarath Chandrand, 44, a software consultant from India, moved with his wife and two young daughters from Raleigh to Toronto in December because he couldn't live with more uncertainty. He applied for his green card in early 2003 and expects it will take at least two more years to get it.
His former employer continues to sponsor his application for permanent residency, hoping that he will eventually return. But Chandrand doesn't know what the future will hold.
"I miss Raleigh, the weather, the people," he said in a phone interview. "But it's a very difficult decision to make, once you've settled in a country, to move out. You go through a lot of mental strain. Making another move will be difficult."
Canada won him over because its residency process takes only a year and a half and doesn't require sponsorship from an employer.
The competition from Canada also worries Plueddeman, who said several of his employees are also applying for residency in both countries. "They'll go with whoever comes first," he said.
And it's not just India and Canada that beckon. New Zealand and Australia are among nations that actively market themselves to professionals in the United States, with perks such as an easy process to get work visas.
New Zealand, with a population of 4 million, has received more than 1,900 applications from skilled migrants and their families in the past two years, said Don Badman, the Los Angeles marketing director for that country's immigration agency. Of those, about 17 percent were non-Americans working in the United States.
Badman's team has hired a public relations agency to get the word out. They have also run ads in West Coast newspapers and attended trade shows, mainly to attract professionals in health care and information technology.
Dana Hutchison, an operating room nurse from Cedar Mountain south of Asheville, could have joined a hospital in the United States that offers fat sign-on bonuses. Instead, she's in the small town of Tauranga, east of Auckland, working alongside New Zealand nurses and doctors.
"It would be hard for me to work in the U.S. again," she said. Where she is now, "the working conditions are so fabulous. Everybody is friendly and much less stressed. It's like the U.S. was in the 1960s."
Limit of 140,000
Getting a green card was never a quick process. The official limit for employment-based green cards is 140,000 annually.
And there is a bottleneck of technology professionals from India and China. They hold many, if not most, of all temporary work visas, and many try to convert their work visa to permanent residency, and eventually full citizenship. But under current rules, no single nationality can be allotted more than 7 percent of the green cards.
In his February economic report, President Bush outlined proposals to overhaul the system for employment-based green cards:
* Open more slots by exempting spouses and children from the annual limit of 140,000 green cards. Such dependents now make up about half of all green card recipients, because workers sponsored by employers can include their family in the application.
* Replace the current cap with a "flexible market-based cap" that responds to the need that employers have for foreign workers.
* Raise the 7 percent limit for nations such as India that have many highly skilled workers.
After steady lobbying from technology companies, Congress is also paying more attention to the issue. The Senate immigration bill had proposed raising the annual cap for green cards to 290,000.
Kumar Gupta, a 33-year-old software engineer, has been watching the legislative proposals as he weighs his options. After six years in the United States, he is considering returning to India after learning that the green card he applied for in November 2004 could take another four or five years.
Being on a temporary work visa means that he cannot leave his job. Nor does he want to buy a home for his family without knowing he will stay in the country.
"Even if the job market is not as good as here, you can get a very good salary in India," he said. "If I have offers there, I will think of moving."
Let's utilize this write up and start quoting the link in our personal comments / emails to other news anchors, commentators, blogs etc.
I thought this deserves it's own thread. Please comment and act.
Many skilled foreigners leaving U.S.
Exodus rooted in backlog for permanent status
Karin Rives, Staff Writer
When the Senate immigration bill fell apart last week, it did more than stymie efforts to deal with illegal immigration.
It derailed efforts to deal with an equally vexing business concern: a backlog in applications for so-called green cards, the coveted cards that are actually pink or white and that offer proof of lawful permanent residency.
Many people now wait six years or longer for the card. There are 526,000 applications pending, according to Immigration Voice, an advocacy group that tracks government data.
Lately, this has prompted an exodus of foreign workers who tired of waiting, to return home or go further afield. With the economies in Asia and elsewhere on the rise, they can easily find work in the native countries or in third nations that are more generous with their visas.
"You have China, Russia, India -- a lot of countries where you can go and make a lot of money. That's the biggest thing that has changed," said Murali Bashyam, a Raleigh immigration lawyer who helps companies sponsor immigrants. "Before, people were willing to wait it out. Now they can do just as well going back home, and they do."
Mike Plueddeman said he lost three employees (one a senior programmer with a doctorate) at Durham-based DynPro in the past two years because they tired of waiting for their green cards.
All three found good jobs in their home countries within a few weeks of leaving Durham, said Plueddeman, the software consultancy's human resource director.
"We are talking about very well-educated and highly skilled people who have been in the labor force a long time," he said. "You hate losing them."
This budding brain drain comes as the first American baby boomers retire and projections show a huge need for such professionals in the years ahead. U.S. universities graduate about 70,000 information technology students annually. Many people say that number won't meet the need for a projected 600,000 additional openings for information systems professionals between 2002 and 2012, and the openings made by retirements.
"We just don't have the pipeline right now," said Joe Freddoso, director of Cisco Systems' Research Triangle Park operations. "We are concerned there's going to be a shortage, and we're already seeing that in some areas."
Cisco has advertised an opening for a data-security specialist in Atlanta for several months, unable to find the right candidate. Freddoso believes the problem will spread unless the government allows more foreign workers to enter the country, and expedites their residency process.
However, not everybody believes in the labor shortage that corporations fret about.
Critics say that proposals to allow more skilled workers into the country would only depress wages and displace American-born workers who have yet to fully recover from the dot-com bust.
"We should only issue work-related visas if we really need them," said Caroline Espinosa, a spokeswoman with NumbersUSA, a Washington, D.C., group pushing for immigration reduction. "There are 2.5 million native born American workers in the math and computer field who are currently out of work. It begs the question whether we truly need foreign workers."
She added that the immigration backlog would be aggravated by raising the cap for temporary and permanent visas, which would make it harder for those who deserve to immigrate to do so.
Waiting since 2003
Sarath Chandrand, 44, a software consultant from India, moved with his wife and two young daughters from Raleigh to Toronto in December because he couldn't live with more uncertainty. He applied for his green card in early 2003 and expects it will take at least two more years to get it.
His former employer continues to sponsor his application for permanent residency, hoping that he will eventually return. But Chandrand doesn't know what the future will hold.
"I miss Raleigh, the weather, the people," he said in a phone interview. "But it's a very difficult decision to make, once you've settled in a country, to move out. You go through a lot of mental strain. Making another move will be difficult."
Canada won him over because its residency process takes only a year and a half and doesn't require sponsorship from an employer.
The competition from Canada also worries Plueddeman, who said several of his employees are also applying for residency in both countries. "They'll go with whoever comes first," he said.
And it's not just India and Canada that beckon. New Zealand and Australia are among nations that actively market themselves to professionals in the United States, with perks such as an easy process to get work visas.
New Zealand, with a population of 4 million, has received more than 1,900 applications from skilled migrants and their families in the past two years, said Don Badman, the Los Angeles marketing director for that country's immigration agency. Of those, about 17 percent were non-Americans working in the United States.
Badman's team has hired a public relations agency to get the word out. They have also run ads in West Coast newspapers and attended trade shows, mainly to attract professionals in health care and information technology.
Dana Hutchison, an operating room nurse from Cedar Mountain south of Asheville, could have joined a hospital in the United States that offers fat sign-on bonuses. Instead, she's in the small town of Tauranga, east of Auckland, working alongside New Zealand nurses and doctors.
"It would be hard for me to work in the U.S. again," she said. Where she is now, "the working conditions are so fabulous. Everybody is friendly and much less stressed. It's like the U.S. was in the 1960s."
Limit of 140,000
Getting a green card was never a quick process. The official limit for employment-based green cards is 140,000 annually.
And there is a bottleneck of technology professionals from India and China. They hold many, if not most, of all temporary work visas, and many try to convert their work visa to permanent residency, and eventually full citizenship. But under current rules, no single nationality can be allotted more than 7 percent of the green cards.
In his February economic report, President Bush outlined proposals to overhaul the system for employment-based green cards:
* Open more slots by exempting spouses and children from the annual limit of 140,000 green cards. Such dependents now make up about half of all green card recipients, because workers sponsored by employers can include their family in the application.
* Replace the current cap with a "flexible market-based cap" that responds to the need that employers have for foreign workers.
* Raise the 7 percent limit for nations such as India that have many highly skilled workers.
After steady lobbying from technology companies, Congress is also paying more attention to the issue. The Senate immigration bill had proposed raising the annual cap for green cards to 290,000.
Kumar Gupta, a 33-year-old software engineer, has been watching the legislative proposals as he weighs his options. After six years in the United States, he is considering returning to India after learning that the green card he applied for in November 2004 could take another four or five years.
Being on a temporary work visa means that he cannot leave his job. Nor does he want to buy a home for his family without knowing he will stay in the country.
"Even if the job market is not as good as here, you can get a very good salary in India," he said. "If I have offers there, I will think of moving."
Let's utilize this write up and start quoting the link in our personal comments / emails to other news anchors, commentators, blogs etc.
I thought this deserves it's own thread. Please comment and act.
dresses Taylor Swift New Hair Style at
dealsnet
08-04 12:15 PM
I have received the card with old number without any restriction in employment. Plain card with name and number. At the SSA office they told me the same. So feel free to get rid of last H1B bundle. (surrender old card for a new freedom card)
Did you recieve old SS# on new card ? or entirely new SS# ?
Did you recieve old SS# on new card ? or entirely new SS# ?
more...
makeup straight hair with angs,
Ann Ruben
06-29 03:00 PM
Note that you cannot legally be required to reimburse certain immigration fees such as the $1500 or $750 ACWIA fee. Also,you cannot legally be required to reimburse USCIS filing fees and/or immigration related legal fees which, when subtracted from your salary, bring your salary below the required LCA wage.
girlfriend This side sweep hairstyle look
eb3retro
09-28 09:35 PM
I will keep it with me until you come back and for sure will return it back to you..you are not believing me..come on???:D:D:D I promise...;););) I will return it safely..
Has anybody travelled TO India with personal gold jewellery? I am not concerned about theft/security. My question is about Customs clearance at the airport. Do we need to declare it or pay customs duty?
If you have any experience doing this, please do share it here.
Thank you.
Has anybody travelled TO India with personal gold jewellery? I am not concerned about theft/security. My question is about Customs clearance at the airport. Do we need to declare it or pay customs duty?
If you have any experience doing this, please do share it here.
Thank you.
hairstyles Taylor swift with curly hair
HV000
08-10 08:47 PM
Reforms To Visa Programs For Highly Skilled Workers.
IMPROVING EXISTING IMMIGRATION
22. The Administration Will Reform And Expedite Background Checks For Immigration. Current mechanisms for conducting immigration background checks are backed up, slowing processing times and endangering national security. The Administration is investing substantial new funds to address the backlog, and the FBI and USCIS are working together on a variety of projects designed to streamline existing processes so as to reduce waiting times without sacrificing security.
23. The President Is Directing The Department Of Homeland Security And The Social Security Administration To Study The Technical And Recordkeeping Reforms Necessary To Guarantee That Illegal Aliens Do Not Earn Credit In Our Social Security System For Illegal Work. Currently, aliens who make Social Security payments while working here legally can continue to accrue credits even if they overstay their visa. Improved data-sharing can lay the foundation for eventual Congressional action to eliminate this practice (which proved an obstacle to comprehensive reform). The relevant agencies are ordered to report to the President with a detailed plan for eliminating the problem.
The funny thing is ONLY now they are thinking about their JOB RESPONSIBILITIES which is to UPHOLD the Law!! However, they have not specified ANY TIMELINE for REFORM!!
SEPTEMBER Rally would be ideal to raise these issues!
ISSUES THAT WE COULD RAISE DURING THE RALLY
1. Eliminate EB Backlog
2. Processing Timeline for I-485
3. Faster processing of FBI Name Check(Questionable process according to USCIS OMBUDSMAN)
4. Uniform Processing Methodology across all USCIS Service Centers
5. Uniform Level of Customer Service across all USCIS Service Centers
6. Increase Coordination between USCIS and DOS
7. Allocation of ALL VISA Numbers by DOS at the beginning of fiscal year rather than a piece meal allocation during the first 3 quarters.
8. More Transparency and flexibility in invoking AC21
9. Decrease the time to invoke AC21 from 6 months to atleast 3 months
IMPROVING EXISTING IMMIGRATION
22. The Administration Will Reform And Expedite Background Checks For Immigration. Current mechanisms for conducting immigration background checks are backed up, slowing processing times and endangering national security. The Administration is investing substantial new funds to address the backlog, and the FBI and USCIS are working together on a variety of projects designed to streamline existing processes so as to reduce waiting times without sacrificing security.
23. The President Is Directing The Department Of Homeland Security And The Social Security Administration To Study The Technical And Recordkeeping Reforms Necessary To Guarantee That Illegal Aliens Do Not Earn Credit In Our Social Security System For Illegal Work. Currently, aliens who make Social Security payments while working here legally can continue to accrue credits even if they overstay their visa. Improved data-sharing can lay the foundation for eventual Congressional action to eliminate this practice (which proved an obstacle to comprehensive reform). The relevant agencies are ordered to report to the President with a detailed plan for eliminating the problem.
The funny thing is ONLY now they are thinking about their JOB RESPONSIBILITIES which is to UPHOLD the Law!! However, they have not specified ANY TIMELINE for REFORM!!
SEPTEMBER Rally would be ideal to raise these issues!
ISSUES THAT WE COULD RAISE DURING THE RALLY
1. Eliminate EB Backlog
2. Processing Timeline for I-485
3. Faster processing of FBI Name Check(Questionable process according to USCIS OMBUDSMAN)
4. Uniform Processing Methodology across all USCIS Service Centers
5. Uniform Level of Customer Service across all USCIS Service Centers
6. Increase Coordination between USCIS and DOS
7. Allocation of ALL VISA Numbers by DOS at the beginning of fiscal year rather than a piece meal allocation during the first 3 quarters.
8. More Transparency and flexibility in invoking AC21
9. Decrease the time to invoke AC21 from 6 months to atleast 3 months
joshraj
10-06 09:37 AM
Anyone with July 27 File Date, Please update receipt recd or not recd
logiclife
10-26 04:35 PM
For people familiar with how databases work:
You have to realize that each page load means a query has to run to a table of 14,000 records (for 14,000 threads) in MySQL database on our limited capacity server and since you have to sort the rows on basis of most recent updates, you have to get all 14,000 rows of result set and then let database sort them in descending order.
The reason for messed up sort order is that the "recent forums posts" has been pointed to a separete table that has recent threads and that seperate table is populated every 1 or 2 minutes from entire table of threads. That's sometimes you update a thread and it takes a while for it to become most recent thread.
For some reason, and we dont know yet, our site has been over loaded. This used to happen during July bulletin and we did the same work around by pointing "recent forum posts" to a smaller table populated thru a stored procedure running every few minutes. Also, during the July bulletin, we upgraded the server processing capacity and doubled the memory. It may be time to upgrade again, or maybe its time for some tune-up with regards to creating an index on the table for threads.
For people not familiar with Databases:
The messed up sort order on "recent forum posts" is by intention an its a work around to avoid site crashes that we have been having due to reasons we dont know yet.
You have to realize that each page load means a query has to run to a table of 14,000 records (for 14,000 threads) in MySQL database on our limited capacity server and since you have to sort the rows on basis of most recent updates, you have to get all 14,000 rows of result set and then let database sort them in descending order.
The reason for messed up sort order is that the "recent forums posts" has been pointed to a separete table that has recent threads and that seperate table is populated every 1 or 2 minutes from entire table of threads. That's sometimes you update a thread and it takes a while for it to become most recent thread.
For some reason, and we dont know yet, our site has been over loaded. This used to happen during July bulletin and we did the same work around by pointing "recent forum posts" to a smaller table populated thru a stored procedure running every few minutes. Also, during the July bulletin, we upgraded the server processing capacity and doubled the memory. It may be time to upgrade again, or maybe its time for some tune-up with regards to creating an index on the table for threads.
For people not familiar with Databases:
The messed up sort order on "recent forum posts" is by intention an its a work around to avoid site crashes that we have been having due to reasons we dont know yet.
No comments:
Post a Comment