Howdy Reader,

This is something for Python Flask developers.
While developing application we usually come across the situation where data fetch is little slow and it is not working as expected. If we are fresher in any kind of Database technologies then we might think that OHH, it is more data(probably max 2K products from single table which only has plain data, no Images or such that and having total of 2K records) and it can be slow. But once you are little experienced you would know that something is missing. First thing that needs to be checked on such scenarios that are you reading any other whole table?(i.e. if you want user specific products, are you reading whole product table, whole user table and then filtering in python or you are doing proper joins?), second thing that needs to be looked at indexes, are they required, if so then create it.
Any ways that theory was for fresher but for how to create constraints and indexes using SQLAlchemy, please look at this link.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s