SQL Server performance problem

[Fred]

I'm on a W7 32bit virtual machine with python 2.7 and SQL Server 2008 with local views referencing Linked Server where the real data resides.
My setup is
Django (1.7.4)
django-pyodbc (0.2.6)
django-pyodbc-azure (1.2.3)  ------------not using this, it was a false start that did not pan out.
mysqlclient (1.3.4)
pip (1.5.6)
pymssql (2.1.1)
pyodbc (3.0.6)
requests (2.5.1)
setuptools (7.0)
I quit using pymssql because I could not get that to work with Django.

I created an ODBC link to my local DB and it works reasonably well until I try to do a join.
Using SQL Server management studio, the join takes about 2 seconds
Using Django and select_related() the join takes 1.5 minutes.

I'm just in the early stages of building my app and am developing simple test scripts to verify the data is as expected.  But I cannot work with this much delay and I'm no expert at how to tune this query.  An example is
    records = models.Admissions.objects.select_related().filter(dischargedatetime=None, datebedinactive=None)

class Residents(models.Model): #~2000 records
    entitysys = models.IntegerField(primary_key=True, db_column='EntitySys') 
    internalid = models.TextField(db_column='InternalID', blank=True) 
    externalid = models.TextField(db_column='ExternalID', blank=True) 
    lastname = models.TextField(db_column='LastName', blank=True) 
    firstname = models.TextField(db_column='FirstName', blank=True) 
...
class Admissions(models.Model):  #~300 records
    episodesys = models.IntegerField(primary_key=True,  db_column='EpisodeSys') 
    resident = models.ForeignKey(Residents, db_column='ResidentSys', blank=True, null=True) 
    episodetype = models.CharField(db_column='EpisodeType', max_length=2, blank=True) 
...

This is a new project and so there is much less data entered than there will be once fully implemented.  Is there a way to improve the performance within the django model framework?

[chj]

Avoid using ODBC. It's horribly slow. While I have no experience with MSSQL, you may have a look at django-mssql: https://django-mssql.readthedocs.org/