Home Spain Forum Spain Guide Moving to Spain Real Estate Healthcare in Spain
Spain
Resources
City Guides
JoinSign In
Cigna International Health Insurance

Expats in Spain: Pros and Cons of Living in Spain

By Betsy Burlingame

Last updated on: May 11, 2020

Summary: Expats in Spain discuss the pros and cons of living in Spain. Topics discussed include lower cost of living, taxation on worldwide income, friendliness of Spaniards, LGBT community, slower pace of life and more.

Expats in Spain - Pros and Cons of Living in Spain

If you are thinking about moving to Spain, we've compiled a list of pros and cons of living in Spain to help with your decision. Most of the information comes from expats living in Spain and some who've lived there in the past.

Lower Cost of Living

Pro: Lower Cost of Living in Spain (it's relative)

"Be careful what you read. Most retirement resources can be overly positive and some ranking lists are misleading. For example Barcelona is 'expensive.' It is compared to more southern parts of Spain. Compared to urban Texas it is actually cheaper. We love it... rent and utilities are cheaper and medical care as well as transportation are also. We don't have a car so you can just imagine all the costs associated with ownership that we save," commented one expat in a discussion about moving to Spain.

Con: Rents & Real Estate Prices Can be High in Some Areas

One expat in Spain said, "We live on the Costa Blanca. It is a little cooler here in the summers (not much) and rights now it's sweater weather although you can be comfortable in a polo shirt at mid day. Rents and real estate here are high but nothing like Madrid or Barcelona. You can get a very nice house for around $450,000 or rent a very nice place for about $1,000 to $ 1,500 depending on if its a house or an apartment. Food here is relatively cheap, wine is great."

Spaniards

Pro: Spaniards Are Among the Nicest People in the World

"Everyone goes out here, you live at the gym, in bars, out on walks, riding bicycle, etc. Everyone here is nice. This is the MAJOR thing we are going to miss. Spain has 45 million of the nicest people I have ever met. Your doctor will be your friend, the local policman will invite you for a drink (he won't pay though, Spaniards are extremely cheap), the mailman will tell you a joke, the cashier at the market will ask about your family. You will fall in love with everything here and that's before you realize the amount of history and culture that is beneath your feet," remarked one expat in Spain.

"I don't think I ever went through any culture shock. Most people I met were very friendly and helpful. Particularly employees of City Council and similar places were nice, they spoke slowly for me and explained things properly. If it was culture shock it was definitely a positive one," mentioned another expat when asked about moving to Spain.

Con: If You're a Quiet Person, the Culture May Be a Bit of a Shock

"Spaniards, like most people from Southern Europe, love loud music, even late at night. I'm more a quiet person," mentioned another expat when asked about moving to Spain," said one expat.

Slower Pace of Life in Spain

Spain

Con: Long Lines & Slow Service are a Part of Life in Spain

"The only thing I should have brought is my patience! Everything here (compared to the UK) seems to take forever, especially when it comes to business matters. There are queues everywhere and the Spanish seem to take it in their stride to stand around for hours just waiting - can be very stressful," remarked one expat living in Barcelona, Spain.

"Paperwork here is a bit of a challenge, and the concept of customer service is certainly not what I am used to seeing. I have pretty much given up on the idea that I can get something done in a single day. Instead, many processes take a week or more to just get an appointment, such as when going to a doctor, requesting house services like a phone or television, or opening an account. For example, it took over a month to get a cellphone number, which would have taken an hour in the US," mentioned another expat when asked about moving to Spain.

"I was kind of frustrated with how slow everything seemed to me. Groceries stores opened at 10:00 am. If I needed something in the afternoon, I'd had to wait until they open after the nap... Around 5:00 pm... Long waiting lines in any government office... Only one person giving forms and answering questions of any type... You won't hear thanks from waiters, most of the time. Should I continue," mentioned another expat in Madrid when asked about moving to Spain.

Pro: Once You Adjust to a Slower Pace of Living, It's a Blessing

Many people who decide to move abroad are looking to slow down and enjoy life. It takes time to adjust to the slower pace, but most expats say that once they do the rewards outweigh the negatives. "Some of the things that frustrated me are now what I appreciate. I enjoy the conversation I have with the people at the fruit store or the post office while I am waiting in line. I like the reliance on our own two feet and not using the car. I appreciate that the family is VERY important and everyone takes off Sunday to spend time with them," said one expat who moved to Barcelona.

Moving to Spain soon? AGS Worldwide Movers is a leader in the international moving industry. Their experience and expertise allows them to guarantee their clients the best quality moving services. Get a Moving Quote

Moving to Spain soon? AGS Worldwide Movers is a leader in the international moving industry. Their experience and expertise allows them to guarantee their clients the best quality moving services. Get a moving quote today.

Spain's Beautiful Beaches & Weather

Peniscola Spain

Pro: Spain Has Amazing Weather, Beautiful Beaches and Coastal Cities

Regardless of whether you end up in a coastal town or inland city, the weather in Spain will not disappoint. If you're looking for a coastal city, the options are endless. "It would be well worth a visit to the Almeria Province which is down on the South Coast and still part of the autonomous region of Andalucia. My partner and I have lived here for nearly 14 years and haven't looked back. We travelled all around the coast of Spain and constantly came back to this area which is less developed and still has a great air of friendliness and is strikingly beautiful. It is also a lot cheaper in terms of buying a house and the cost of living too. Once you go into the realms of city or coastal life around Marbella for example it is probably double what you would pay here in this area to go out," commented one expat in Spain.

Con: Coastal Cities Can be Very Crowded in Summer

Like anywhere in the world, coastal cities and towns get crowded in summer. For any beach lover, that shouldn't be a surprise. Think of the summer season as a time to meet more Spaniards, travel inland for a break from the beach and an income opportunity if you rent out your seaside property.

Healthcare in Spain

Pro: Great Healthcare at Affordable Rates in Spain

"Before I first moved to Europe, one year ago, I was afraid that our excellent USA medical care was a sacrifice I wasn't willing to make. So I took out a very expensive insurance policy (about $15M per year) and 'damned the torpedoes.' Since then I've learned that France has better medical care, and that Spain is pretty much up there too. My insurance costs are down to under $300 per month which is below what I would have paid with Medicare + excess coverage. I would suggest that you check carefully what hospitals, and what rating these hospitals have in the city/area you want to live. Then I would check which national insurance will cover you and what requirements they have. We are in Spain and are using SANITAS. So far, so good. The medical care in Switzerland, France and Spain, in which we have lived over the past 12 months, has been good to exceptional," explained one expat.

For more information about healthcare and health insurance, read our article, 7 Important Tips about Healthcare for Expats in Spain.

Con: You'll Need Private Health Insurance When You First Arrive in Spain

According to the Consulate of Spain in Washington DC, all four types of residence visas require you to have overseas medical insurance from a company licensed to operate in Spain (Proof of Medical Insurance Requirement).

Expats in Spain may get a free expat health insurance quote from our partner Allianz Care, whose plans ensure that you have access to quality healthcare whenever you need it. Allianz's flexible solutions allow you to tailor your cover to meet your needs and budget. Get a Quote

Expats in Spain may get a free expat health insurance quote from our partner Allianz Care, a leader in international insurance for expatriates. Allianz's plans ensure that you have access to quality healthcare whenever you need it. Their flexible solutions allow you to tailor your cover to meet your needs and budget..

Taxes in Spain for Expats

Con: Spain Taxes Expats on Their Worldwide Income

"The problem with Spain is that they tax you on worldwide income and that includes your social security and pension income due to an agreement with the U.S.. We would pay more income taxes in Spain than we currently do in the U.S. - talk to a Spanish tax specialist on this for your personal liability," remarked one expat in a discussion about choosing to live in Spain or France.

"Spain's annual income taxes are calculated based on world-wide income. These can then be deducted from your US income tax. The bigger issue is their wealth tax calculated on your net worth annually. The exclusion amount has been decreased from $750K to $500K and each person has to declare - there is no category for married couples. Government pensions are exempt. It also depends on where you live in Spain. Here in Barcelona you pay 100% of the wealth tax yet in Madrid you pay 0%. We have no government pensions so we are taxed on our lifetime savings which means we owe an exorbitant amount each year. We love it here but we plan to avoid being tax residents in the future by living here less than 183 days per year. We did not purchase a residence of any kind because that will make you a tax resident no matter how long you are in the country," explained another expat.

Pro: Lower Cost of Living Offsets Taxes

"We have had several trips to the area and, if the exchange rate stays below $1.25, it is very affordable. Good rentals can be had for $350 and up. Food is very reasonably priced with good selection and alcohol is extremely inexpensive. Healthcare is very low cost," said one expat.

Family is a Priority in Spain

Family Hiking in Spain

Pro: Expat Families Will Appreciate Spain's Family-Friendly Culture

"Typically the Spaniards priority is family. They have extended family nearby and visit quite often. You may be friends at work, but once the work day is over the friendship normally does not extend to socializing outside the office. Soccer (or futbol) is big and a good topic of conversation. Additionally people enjoy travelling from one side of the country to the other on holiday. If Spain has a holiday on Thursday, schools will give the children off on the Friday too so that families can travel. The winter and spring breaks are very long...again so people can travel. Folks are always going somewhere," said one expat who moved to Madrid.

Con: If You're an Entrepreneur, The Family-Friendly Culture May be a Challenge

Many Spaniards take most of their obligatory vacation days in August and some businesses even shut down for the month. For Americans working in Spain or running a small business there, it may be a difficult thing to adjust to.

Deciding Where to Live in Spain

Pro: There are Many Amazing Places to Live in Spain

"My husband and I just picked up our nonlucrative visas today! We are moving to Girona which is a small city just north of Barcelona. The weather is nice, it is close to the coast, to the mountains, and to France. We saw a number of apartments in the $1000 range, although we ended up with one a little more because we wanted to be very central. We are not getting a car and will rely on the amazing train and bus system plus inexpensive rental cars when we need them," said a woman preparing to move to Girona in a discussion about moving to Spain.

Read our article, 5 Affordable Places to Retire in Spain, for ideas on affordable places to live. Plus, check out our article, 5 Best Places to Live in Spain.

Con: With So Many Great Cities and Towns, It Can Be Difficult to Decide Where to Live

"It all depends on what you are looking for. But I'll give you some insight. We don't live on the Costa del Sol. We live on the Costa Blanca. It is a little cooler here in the summers (not much) and rights now it's sweater weather although you can be comfortable in a polo shirt at mid day. We live in Javea. It is a mix of very Spanish (old town) to very British and then mixed German/Dutch. There are three distinct areas to Javea: 1) the port which is lively and has nice shops and restaurants 2) old town, very spanish with great tapa bars an shops 3) Arenal which is the beach and is very much like Miami Beach (if you like that stuff), more family oriented but very touristy. There are lots of towns around here to visit, farmers markets, etc. and airports are about an hour away. There are tennis clubs, bicycling, paddle tennis, golf courses and many beaches and coves. Hospitals are nearby and pharmacies are plentiful. So you might want to drive up this way. Javea reminds me of Arizona/New Mexico," said one expat.

"There are good values and quality of life in the Valenciana and Alicante provinces, both in Communidad Valenciana, with typically temperate weather. Towns on the Mediterranean or inland if you want a finca (farm) provide good options, but depends on what your priorities are. Make a list of those first, and see what general areas match, and then test drive by staying in some vacation rentals for enough time to get a feel for the town and neighborhood," advised another expat.

Real Estate in Spain

Barcelona Spain

Pro: Properties in Spain are Less Expensive Than Many Other Cities in Europe and the US

"To buy a similar property in London would be around double and rates in the UK are very high," said one expat. "It is cheaper here than many large cities in the US, yet choice ultimately depends on your budget and needs. Prices may be lower the farther you go from Ciutat Vella, plus you will still have metro access. You can get a good sized apartment with 2 or more bedrooms and at least one bathroom for between 1000-1500 euros per month. Utilities and internet/TV are generally cheaper too," added another expat from the US.

Con: Costs Involved in Buying Property in Spain

"The costs involved in buying a property here is very expensive compared to UK, for example, an estate agent here takes 10% commission compared to 1.5% in UK. Stamp duty here is 7%, in UK it is only payable on properties over a certain level and even then is only around 2%. Capital Gains Tax is also payable on selling property here, even if this is your only residence, unlike UK. Therefore buying and selling property in Spain is not a fast way to make money, unlike in UK," remarked an expat who moved to Barcelona, Spain.

The Large Expat Population in Spain

Pro: Expat Friends Can Be Incredibly Supportive

According to the Instituto Nacional de Estadistica, there are over 4.5 million expats in Spain. Groups like Barcelona Women's Network, International Women's Club of Barcelona, International Newcomer's Club of Madrid are a great way to meet other expats when you're getting settled.

"Until one gets their own group of friends it is a very lonely time. Having moved prior, I knew that the most important thing for me was to find friends ASAP. So I joined women's groups and volunteered at school. That helped a lot as there were many people in the same boat as me," said one expat who moved to Barcelona.

Con: It Can be Hard to Immerse Yourself in the Spanish Culture When There are So Many Expats

If you're looking for an authentic, local experience, you may find it more difficult to immerse yourself with so many expats around. In that case, rent a home or flat in an area that is not popular among expats, talk Spanish as often as possible and join local volunteer organizations to meet locals. These strategies can help. However, don't be too quick to isolate yourself from expats. When times get tough and you're feeling homesick, facing a health problem or enduring some other challenge, expats can be your best source of help and support.

Long-Term Residency in Spain

Pro: There are Several Options for Achieving Long-Term Residency

There are three main types of long-term residence visas plus several other options for investors, property buyers, entrepreneurs and highly skilled professionals. The main types are The Residence Visa (Non-Lucrative), the Work & Residence Visa and the Student Visa. Read our article, 8 Tips for Obtaining Residency in Spain, for more information about long-term visa options.

Con: It's Not Easy to Get a Job in Spain

If you're planning to work while living in Spain as a long-term resident, you have a few options and you'll need to plan carefully. It's difficult to be hired in a job that could be taken by a Spaniard. "Non-lucrative [visa] refers to not working for a company in Spain where you would be taking away one of the few jobs there are from Spanish citizens. Your own online business would not be considered especially if it is based in another country. In theory your business could create local jobs - a good thing," said one expat. Another added, "Think of it this way: if you are taking a job from a Spanish citizen, it would be lucrative. If you are not (such as retired, independently wealthy, or working a job out of another country but living in Spain), then it is non-lucrative. You still have to file taxes in both countries, but a non-lucrative visa is how I lived in Spain for two years while working a distance job in the US. I was not taking a job away from a Spanish worker, so it was considered non-lucrative."

The LGBT Community in Spain

Valencia Spain

Pro: The Majority of Spaniards are Very Accepting

"This is in stark contrast to just about anywhere else in the western world -- the EU in particular. I have been watching Spanish LGBT law evolve for a couple of decades now, and the accomplishments have been nothing short of stellar. The new (November 2017) anti-transgender discrimination law in Valencia is incredibly good -- light years beyond anything we could hope to have during the remainder of my life in the US. There are also excellent laws protecting transgender people throughout many of the autonomous communities. It is my hope that the PSOE can pass anti-trans discrimination laws at the national level fairly soon. And of course there are already excellent laws regarding sexual orientation at the national level," said one man in a discussion about whether Spain is a safe place for LGBT people to move. He went on to ask expats in Spain, "So my question to all of you with firsthand familiarity with conditions in both countries is whether Spain is indeed a safer country for LGBT people. Furthermore, if it is, what would be your recommendations for where we should relocate -- and why? (We are currently thinking Valencia--great antidiscrimination laws, low hate crimes rates, pretty, and we are also told friendly to Americans.)"

One Expat Exchange member replied, "To add more about our experiences, we have felt very safe in Barcelona and have visited Valencia several times where it might be somewhat cheaper to live. We have been active in two Gay choruses and have no problems holding hands in public (beyond my deeply seeded resistance after living in Texas for over 50 years.) The press have over-emphasized the existing discord in Catalunya and the president who sent the national police to try to prevent voting here has been impeached. So we can say with regard to LGBT issues we have had no qualms about Spain."

Another added, "I am gay and my husband and I recently spent 3 weeks in Valencia, where I have both lived for two years in the past (from 2013-2015) and visited since for extended vacations. In fact, we plan to move back to Spain as soon as we can make that happen with online jobs. To the questions you posted: I can empathize with the cross-national feelings of being an American (in the Atlanta, GA area) and knowing firsthand what Spain is like for LGBT residents. In short, it is great. People really don't care who you are holding hands with, they don't care if you are married to a same-sex person, they don't care if you are somewhat outside of the 'norm'. My husband is significantly younger than I am, and they don't even bat an eye at that. We walked pretty much all over the city holding hands, and aside from some older ladies giving us the frowny face, nobody cared. But let's talk personal for a minute: My friends in Valencia are all kinds of people, too, and the fact that I am a man married to a man makes absolutely no difference. I have family there, and my Spanish family treats me like, well, family. As far as political movements go, the Spanish people on the street don't care what the political party is, but they DO care if someone is being mistreated by the authorities. So, as a transgender person, what should you know? Medications may not be available in Spain, as some medications (referring specifically to Truvada) may not be available. I would find a way to check that you will be able to buy what you need at the pharmacy. Want to know why I recommend Valencia? Check out my blog at ValenciaAtLast.com. I am definitely a huge fan of the city!"

Con: Older Generations May Not Be as Accepting

As mentioned above, "We walked pretty much all over the city holding hands, and aside from some older ladies giving us the frowny face, nobody cared." There will always be those who judge others. But, given how progressive Spain is from a legal standpoint and how friendly most Spaniards are, Spain is a great option for those in the LGBT community.

International Health Insurance in Spain

Get a free international health insurance quote from our partner, Allianz Care, whose plans ensure that you have access to quality healthcare whenever you need it. Allianz's flexible solutions allow you to tailor your cover to meet your needs and budget.

Join our Spain Expat Forum

Visit our Spain Forum and talk with other expats who can offer you insight and tips about living in Spain.

Read Next

Moving-to-ValenciaMoving to Valencia

Expats moving to Valencia enjoy life on the Mediterranean coast and a cost of living that is lower than what expats in Barcelona and Madrid must absorb.

Moving-to-BarcelonaMoving to Barcelona

Expats in Barcelona enjoy a beautiful city on the Mediterranean Sea and one of the most popular cities in Europe. Here is some great advice from expat that already live there.

10-Tips-for-Living-in-Spain10 Tips for Living in Spain

Expats Living in Spain offer their advice for others making the move to the nation on the Iberian peninsula. From what to bring, to learning Spanish, culture shock and more, read on to learn how to settle into your new life as an expat in Spain.

5-Best-Places-to-Live-in-Spain5 Best Places to Live in Spain

Expats in Spain have a lot of opinions as to the best places to live in Spain. It all comes down to preferences, resources and where you are in life. Here's a good start in your research for deciding where to live in Spain as an expat!

7-Things-to-Know-Before-Moving-to-SpainMoving to Spain: 7 Things to Know Before Moving to Spain

Expats move to Spain from all over the world. People of all ages move there to work, retire, or just enjoy the culture and Spain's natural beauty. With so many places to choose from, our tips for moving to Spain will get you started on picking the perfect place for you.

About the Author

Betsy Burlingame Betsy Burlingame is the Founder of Expat Exchange. She launched Expat Exchange in 1997 as her Master's thesis project at NYU. Some of Betsy's more popular articles include 6 Best Places to Live in Costa Rica, 12 Things to Know Before Moving to The Dominican Republic and 7 Tips for Obtaining Residence in Italy. Betsy loves to travel and spend time with her family. Connect with Betsy on LinkedIn.

Cigna International Health Insurance

Write a Comment about this Article

Sign In to post a comment.
addacomment

Comments about this Article

guest
May 11, 2020 17:29

I am a Portuguese-American and have dual citizenship since my parents are from Portugal. I live in Portugal now . As someone who don’t Spanish but European, I will day that some of what you said was quite offensive....Spaniards are cheap??? That is just plain rude to say and such a generalizaiton. So, because it is different than your country of origin, it is cheap? It is quite offensive when a foreigner comes in and makes these sweeping conclusions about a country which has literally so many regions which are autonomous...it is so different in each regions. I suggest you reflect in your cultural bias .

Updated On: Jul 24, 2018

First Published: Jul 24, 2018

Cigna Expat Health InsuranceExpatriate Health Insurance

Get a quote for expat health insurance in Spain from our partner, Cigna Global Health.
Get a Quote

Culture-Shock-in-Granada-An Expat Talks about Culture Shock & Living in Granada , Spain

One expat in Granada appreciates the fresh air and food, the weather and the focus on family. He says that life is slower in Granada and advises newcomers to learn Spanish before they arrive.

One expat in Granada appreciates the fresh air and food, the weather and the focus on family. He says that life is slower in Granada and advises newcomers to learn Spanish before they arrive. ...

Living-in-ValenciaAn Expat Discusses Living in Valencia, Spain

An expat in Valencia talks about enjoying the Mediterranean lifestyle. You'll need to learn Castellano and a little Valenciano.

An expat in Valencia talks about enjoying the Mediterranean lifestyle. You'll need to learn Castellano and a little Valenciano. ...

Moving-to-ValenciaMoving to Valencia

Expats moving to Valencia enjoy life on the Mediterranean coast and a cost of living that is lower than what expats in Barcelona and Madrid must absorb.

Expats moving to Valencia enjoy life on the Mediterranean coast and a cost of living that is lower than what expats in Barcelona and Madrid must absorb....

Moving-to-BarcelonaMoving to Barcelona

Expats in Barcelona enjoy a beautiful city on the Mediterranean Sea and one of the most popular cities in Europe. Here is some great advice from expat that already live there.

Expats in Barcelona enjoy a beautiful city on the Mediterranean Sea and one of the most popular cities in Europe. Here is some great advice from expat that already live there....

12-Expats-Talk-About-What-Its-Like-Moving-to-Spain12 Expats Talk About What It's Like Moving to Spain

Expats in Spain share their experiences moving to Spain. From what to bring to learning Spanish, culture shock to finding a flat.
Expats in Spain share their experiences moving to Spain. From what to bring to learning Spanish, culture shock to finding a flat. ...

Spain Guide
Other Links
Our Story Our Team Contact Us Submit an Article Advertising Travel Warnings

Copyright 1997-2020 Burlingame Interactive, Inc.

Privacy Policy Legal


Debugging Information
ColdFusion Server Enterprise 9,0,2,282541
Template /lib_rd.cfm
Time Stamp 30-May-20 06:03 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 173.245.54.145
Host Name 173.245.54.145


Execution Time

Total Time Avg Time Count Template
126 ms 126 ms 1 top level /home/www/html/lib_rd.cfm
41 ms 41 ms 1 /home/www/html/navrightmidcolumn_rdesign5.cfm
41 ms 41 ms 1 /home/www/html/navsidesbottom_rdesign5.cfm
39 ms 39 ms 1 /home/www/html/navcontentbox.cfm
16 ms 16 ms 1 /home/www/html/commentsnew_rdesign4.cfm
14 ms 14 ms 1 /home/www/html/navtop_rdesign5.cfm
13 ms 13 ms 1 /home/www/html/lib_rd_readnext.cfm
11 ms 11 ms 1 /home/www/html/breadcrumb.cfm
9 ms 9 ms 1 /home/www/html/navbottomad_rdesign5.cfm
7 ms 7 ms 1 /home/www/html/navleader_rdesign5.cfm
6 ms 2 ms 4 /home/www/html/nativerotationtop_tester13.cfm
5 ms 5 ms 1 /home/www/html/navmpu_rdesign5.cfm
4 ms 4 ms 1 /home/www/html/Application.cfm
3 ms 3 ms 1 /home/www/html/navmeta_rdesign4.cfm
2 ms 2 ms 1 /home/www/html/rewritearticlefirsttitle.cfm
1 ms 1 ms 1 /home/www/html/constants.cfm
1 ms 0 ms 12 /home/www/html/rewritearticle.cfm
0 ms 0 ms 1 /home/www/html/bottommobilenav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/bottomnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/leftnav_rdesign5.cfm
0 ms 0 ms 1 /home/www/html/natad/native_5104_45430.txt
0 ms 0 ms 2 /home/www/html/navinjection.cfm
0 ms 0 ms 1 /home/www/html/navjoin_rdesign5.cfm
0 ms 0 ms 2 /home/www/html/rewritecityname.cfm
0 ms 0 ms 2 /home/www/html/rewritenetworkname.cfm
0 ms 0 ms 2 /home/www/html/rewriteqoptionsctry.cfm
0 ms 0 ms 2 /home/www/html/rewritereport.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/datasources.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/ibkey.cfm
0 ms 0 ms 1 /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
132 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GeneralSet (Datasource=forum, Time=0ms, Records=1, Cached Query) in /var/www/expatexchange.com/expat/queries/qry_GeneralSet.cfm @ 18:03:33.033
  SELECT * FROM genset 
WHERE dbname = "ee"
UpdateUserVisits (Datasource=forum, Time=3ms, Records=1) in /home/www/html/Application.cfm @ 18:03:33.033
      	  UPDATE users
      	  SET uservisits = uservisits + 1              
       	  WHERE username = 'guest'
    	
getArticle2 (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 18:03:33.033
	Select *
	From articles
	Where articleID = 5104
    and type <> 9
    and type <> 7
getsponsor (Datasource=expert, Time=1ms, Records=0) in /home/www/html/lib_rd.cfm @ 18:03:33.033
	Select *
	From sponcers
	Where sponcerID = 0 
getreportnetworks (Datasource=expert, Time=1ms, Records=1) in /home/www/html/lib_rd.cfm @ 18:03:33.033
	Select articlePlacement.networkID, articles.general, networkname, hitopic, hidescript, authorurl, title
	From articles, articlePlacement, Networks
	Where articlePlacement.articleID = 5104 
	and articles.articleID = 5104 
	and articlePlacement.networkID = Networks.networkID
	and articles.hinet = 'y'
  and (articles.general = 'no' or articles.general = 'city')
    and articles.hitopic <> ''
    and articles.hidescript <> ''
	and isCity <> "hold"
	AND networktype <> 2
	AND networktype <> 3
	AND networktype <> 4
	AND networktype <> 5
	AND networkname <> 'national'
	AND networkname <> 'Global Listing'
	AND (isCity = 'Country') 
citystatus (Datasource=expert, Time=0ms, Records=0) in /home/www/html/lib_rd.cfm @ 18:03:33.033
	Select articlecityplace.citynetworkid, citynetworks.networkid, city, title, hitopic, hidescript, authorurl, Networks.networkname, citynetworks.guidelevel, citynetworks.shortname
	From articlecityplace, citynetworks, articles, Networks
	Where articlecityplace.articleID = 5104
	and Networks.networkid = citynetworks.networkid
	and articles.articleID = 5104
	and citynetworks.citynetworkid = articlecityplace.citynetworkid
GetNetworks (Datasource=expert, Time=0ms, Records=153, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 18:03:33.033
	Select *
	From Networks
	where isCity = 'country'
	order by networkname
getname (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 18:03:33.033
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 101 
getcities (Datasource=expert, Time=1ms, Records=8) in /home/www/html/navmeta_rdesign4.cfm @ 18:03:33.033
	Select *
	From citynetworks
	Where networkID = 101
	and status <> 'hold'
	ORDER by city
GetForums (Datasource=forum, Time=0ms, Records=154, Cached Query) in /home/www/html/navmeta_rdesign4.cfm @ 18:03:33.033
  SELECT f.frmid, frmname, f.catid
  FROM forums f
  WHERE dbname = "ee"
and frmname <> "ee"
and frmname <> "Ecuador Welcome Forum"
and f.catid = 2
  GROUP BY f.frmid
  ORDER BY frmname
commentcount (Datasource=forum, Time=0ms, Records=1) in /home/www/html/navmeta_rdesign4.cfm @ 18:03:33.033
  SELECT m.msgdate, m.msgid
  FROM comments m 
  WHERE m.tpcid = 5104 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid DESC
checklog (Datasource=stats, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 18:03:33.033
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.145'
and logtime > "2020-02-29"
and param1 = 'aw'
ORDER BY logtime DESC
checklogother (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 18:03:33.033
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.145'
and logtime > "2020-05-30 00:00:00.000"
and logtime < "2020-05-30 23:59:59.999"
and param1 <> 'aw'
and param1 <> 'awdyn'
ORDER BY logtime DESC
checklogdynamicpre (Datasource=stats, Time=0ms, Records=0) in /home/www/html/navtop_rdesign5.cfm @ 18:03:33.033
SELECT *
FROM tracking
WHERE ipaddress = '173.245.54.145'
and logtime > "2020-05-23"
and param1 = 'awdyn'
ORDER BY logtime DESC
contentcheck (Datasource=expert, Time=0ms, Records=1) in /home/www/html/navtop_rdesign5.cfm @ 18:03:33.033
	SELECT *
	From contentcountcountry
	Where networkid = 101 
gettopbanner (Datasource=expert, Time=2ms, Records=0) in /home/www/html/navleader_rdesign5.cfm @ 18:03:33.033
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight < 8
    and toDate > "2020-05-29"
    and fromDate < "2020-05-30"
gettopbanner (Datasource=expert, Time=2ms, Records=2) in /home/www/html/navleader_rdesign5.cfm @ 18:03:33.033
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
    and toDate > "2020-05-29"
    and fromDate < "2020-05-30"
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navleader_rdesign5.cfm @ 18:03:33.033
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
getarticlesection (Datasource=expert, Time=1ms, Records=1) in /home/www/html/breadcrumb.cfm @ 18:03:33.033
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 5104 
checkcitynetwork (Datasource=expert, Time=0ms, Records=0) in /home/www/html/breadcrumb.cfm @ 18:03:33.033
		Select *
		From citynetworks, articlecityplace
		Where articlecityplace.articleID = 5104 
		and articlecityplace.citynetworkid = citynetworks.citynetworkid
		and citynetworks.status = 'live'
	
getlivingintro (Datasource=expert, Time=9ms, Records=1) in /home/www/html/breadcrumb.cfm @ 18:03:33.033
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg, topic
	From articles, articlePlacement, articleCategories
	Where hitopic <> ''
	and articlePlacement.networkID = 101 
	AND articlePlacement.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    and articleCategories.articleID = articles.articleID
    	and hidescript <> ''
    and type = '3'
    and sectionintro = 'y'
   and articleCategories.section = '6'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
     and hpimg <> 'none'
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-05-30"

    ORDER by articles.articleID desc
    
getnatadcount (Datasource=expert, Time=0ms, Records=48) in /home/www/html/lib_rd.cfm @ 18:03:33.033
SELECT tag
FROM natadoptions 
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 18:03:33.033
SELECT *
FROM natadoptions 
WHERE 'hiheader' = tag
getnatadtype (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 18:03:33.033
SELECT *
FROM natadoptions 
WHERE natadtypeid = 1 
getnatadbottom (Datasource=expert, Time=0ms, Records=2) in /home/www/html/nativerotationtop_tester13.cfm @ 18:03:33.033
SELECT resourceid, headerparagraph as adcode, headerparagraphweight, natads.natadid
FROM natads, natadPlacement
WHERE headerparagraphtype = 1
and natadPlacement.networkID = 101
and natadPlacement.natadid = natads.natadid
and headerparagraphend > "2020-05-29"
and headerparagraphstart < "2020-05-30"
and headerparagraphstatus = 'live'

and headerparagraphweight = 'high'
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 18:03:33.033
SELECT *
FROM natadoptions 
WHERE 'hisentence' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 18:03:33.033
SELECT *
FROM natadoptions 
WHERE natadtypeid = 2 
getnatadbottom (Datasource=expert, Time=0ms, Records=2) in /home/www/html/nativerotationtop_tester13.cfm @ 18:03:33.033
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 2
and natadPlacement.networkID = 101
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-05-29"
and natsentencestart < "2020-05-30"
and natsentencestatus = 'live'

and natsentenceweight = 'high'
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 18:03:33.033
SELECT resourceid, natsentence as adcode, natsentenceweight, natadid
FROM natads 
WHERE natadid = 41
and natsentencetype = 2 
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 18:03:33.033
SELECT *
FROM natadoptions 
WHERE 'movesentence' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 18:03:33.033
SELECT *
FROM natadoptions 
WHERE natadtypeid = 7 
getnatadbottom (Datasource=expert, Time=1ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 18:03:33.033
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 7
and natadPlacement.networkID = 101
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-05-29"
and natsentencestart < "2020-05-30"
and natsentencestatus = 'live'

and natsentenceweight = 'high'
getnatadtopull (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 18:03:33.033
SELECT *
FROM natadoptions 
WHERE 'realtysentence' = tag
getnatadtype (Datasource=expert, Time=0ms, Records=1) in /home/www/html/nativerotationtop_tester13.cfm @ 18:03:33.033
SELECT *
FROM natadoptions 
WHERE natadtypeid = 44 
getnatadbottom (Datasource=expert, Time=0ms, Records=0) in /home/www/html/nativerotationtop_tester13.cfm @ 18:03:33.033
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 44
and natadPlacement.networkID = 101
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-05-29"
and natsentencestart < "2020-05-30"
and natsentencestatus = 'live'

and (natsentenceweight = 'medium' or natsentenceweight = 'high' or natsentenceweight = 'low')
getnatadbottom (Datasource=expert, Time=0ms, Records=0) in /home/www/html/nativerotationtop_tester13.cfm @ 18:03:33.033
SELECT resourceid, natsentence as adcode,  natsentenceweight, natads.natadid
FROM natads, natadPlacement
WHERE natsentencetype = 44
and natadPlacement.networkID = 101
and natadPlacement.natadid = natads.natadid
and natsentenceend > "2020-05-29"
and natsentencestart < "2020-05-30"
and natsentencestatus = 'live'
getarticlesection (Datasource=expert, Time=0ms, Records=1) in /home/www/html/lib_rd_readnext.cfm @ 18:03:33.033
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 5104 
gettaxgeneral (Datasource=expert, Time=10ms, Records=5) in /home/www/html/lib_rd_readnext.cfm @ 18:03:33.033
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 101 
	AND articlePlacement.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and summary <> ''
    and articles.articleID <> 5104
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-05-30"

    ORDER by articles.articleID desc
    
gettopbanner (Datasource=expert, Time=3ms, Records=0) in /home/www/html/navbottomad_rdesign5.cfm @ 18:03:33.033
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
	and weight < 8
    and toDate > "2020-05-29"
    and fromDate < "2020-05-30"
        and banners.promised = ''
    and banners.type <> 'swf'
gettopbanner (Datasource=expert, Time=3ms, Records=2) in /home/www/html/navbottomad_rdesign5.cfm @ 18:03:33.033
	Select *
	From banners
	WHERE status <> "hold"
	AND position = "eebanner"
    and toDate > "2020-05-29"
    and fromDate < "2020-05-30"
        and banners.promised = ''
    and banners.type <> 'swf'
UpdatePageViews (Datasource=expert, Time=3ms, Records=1) in /home/www/html/navbottomad_rdesign5.cfm @ 18:03:33.033
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 865 
gethpbox (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 18:03:33.033
	Select *
	From banners
	WHERE status <> "hold"
	AND (position = "eehpbox" or position = "eehpboxglobal")
    and toDate > {ts '2020-05-29 18:03:33'}
    and fromDate <{ts '2020-05-30 18:03:33'}
    and banners.type <> 'swf'
    
UpdatePageViews (Datasource=expert, Time=2ms, Records=1) in /home/www/html/navmpu_rdesign5.cfm @ 18:03:33.033
  UPDATE banners
  SET impressions = impressions + 1
  WHERE bannerid = 866 
GetMessages (Datasource=forum, Time=1ms, Records=1) in /home/www/html/commentsnew_rdesign4.cfm @ 18:03:33.033
  SELECT *
  FROM comments m 
  WHERE m.tpcid = 5104 
  and m.commenttype = 1
  and m.isapproved = 1
  ORDER BY msgid ASC
GetUser (Datasource=forum, Time=0ms, Records=0) in /home/www/html/commentsnew_rdesign4.cfm @ 18:03:33.033
  SELECT *
  FROM users
  WHERE userid = 2 
getarticlesection (Datasource=expert, Time=1ms, Records=1) in /home/www/html/navrightmidcolumn_rdesign5.cfm @ 18:03:33.033
SELECT *
FROM articleCategories
WHERE articleCategories.articleID = 5104 
checkculturefeature (Datasource=expert, Time=9ms, Records=2) in /home/www/html/navcontentbox.cfm @ 18:03:33.033
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 95
      
         and networkid = 101 
         and city <> ''
     and date > '2013-04-01'
         order by date DESC
getsummary (Datasource=reports, Time=1ms, Records=1) in /home/www/html/navcontentbox.cfm @ 18:03:33.033
		Select summary, hiimg 
		FROM answers
         where answerid = 76449
         and summary <> ''
checklivingfeature (Datasource=expert, Time=8ms, Records=1) in /home/www/html/navcontentbox.cfm @ 18:03:33.033
		Select networkname as ctry, city, networkid, rid, networkname, answerid
		FROM allreports
         where rid = 58
           and city <> ''
      
         and networkid = 101 
        and date > '2013-04-01'
		order by date DESC
getsummary (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 18:03:33.033
		Select summary, hiimg 
		FROM answers
         where answerid = 75819
         and summary <> ''
gettaxgeneral2 (Datasource=expert, Time=7ms, Records=2) in /home/www/html/navcontentbox.cfm @ 18:03:33.033
	Select title, hitopic, hidescript, author, articles.articleID, hiimg, summary, authorurl, hpimg
	From articles, articlePlacement
	Where hitopic <> ''
	and articlePlacement.networkID = 101 
	AND articlePlacement.articleID = articles.articleID
	and hidescript <> ''
    and type = '3'
    and articles.topic <> 'Weekly Quizzes'
   	and articles.topic <> 'Weekly Quizzes: Answers'
    and general <> 'bb'
    and hpimg <> 'none'
    and summary <> ''
    and (articles.author = 'Betsy Burlingame' or articles.author = 'Joshua Wood')
    and publishdate < "2020-05-30"

    ORDER by articles.articleID desc
    
checkrptarticles (Datasource=reports, Time=6ms, Records=1) in /home/www/html/navcontentbox.cfm @ 18:03:33.033
		Select *
		FROM rptarticles, rptarticlenetworks
         where rptarticles.rptarticleID = rptarticlenetworks.rptarticleID
       and rptarticles.publishdate < "2020-05-30"
     
         and rptarticlenetworks.networkid = 101 
    ORDER by rptarticles.rptarticleID desc
    
getreportarticle (Datasource=reports, Time=1ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 18:03:33.033
	Select *
	From rptarticles, rptarticlenetworks
	Where rptarticles.rptarticleID = 10
	and rptarticlenetworks.rptarticleID = rptarticles.rptarticleID
getnameforarticle (Datasource=expert, Time=0ms, Records=1) in /home/www/html/rewritearticlefirsttitle.cfm @ 18:03:33.033
	Select networkname, forumLink, frmid, networktype, isCity, hot, networkID, usekeywords, metatitle, shortname, shortnamecap
	From Networks
	Where networkID = 101 
getrptarticlephotos (Datasource=reports, Time=0ms, Records=1) in /home/www/html/navcontentbox.cfm @ 18:03:33.033
SELECT  hiimg
FROM rptarticles
where rptarticleID = 10
and hiimg <> ''


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/home/www/html/lib_rd.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=www.expatexchange.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
PATH_INFO=
PATH_TRANSLATED=/home/www/html/lib_rd.cfm
QUERY_STRING=articleID=5104&networkid=101
REMOTE_ADDR=173.245.54.145
REMOTE_HOST=173.245.54.145
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/lib_rd.cfm
SERVER_NAME=www.expatexchange.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache
WEB_SERVER_API=
Session Variables:
cfid=28716891
cftoken=53008375
sessionid=IBEXPATEXCHANGE.COM_28716891_53008375
urltoken=CFID=28716891&CFTOKEN=53008375
URL Parameters:
articleID=5104
networkid=101
Debug Rendering Time: 11 ms