Best Practices? A performance related question
Good day. Please I want to convert this JSON into a PostgreSQL database. I am thinking of placing location and contacts in separate tables. The website connected to the database is to allow a user to search for temples either by the NAME or CITY only. Also, it may also have a page where by the user can pull data based on the location they select on a map or list of countries.
My question is would having multiple tables in this case impact performance? Would it be better to put all into one table? The search features I intend to implement are auto suggestions, full text and fuzzy search.
I expect to have records of about 3000 -4000 temples.
My question is would having multiple tables in this case impact performance? Would it be better to put all into one table? The search features I intend to implement are auto suggestions, full text and fuzzy search.
I expect to have records of about 3000 -4000 temples.
