Hi all,

I am building a search app. that will query an API. The app. will also store
search terms in a very simple table structure.

Big question: if the app. eventually hit 10 million searches and I was
storing every single search term, would the table hold or would I run into
issues?

Also, is it "ok" to check if each search query exists or not while I save
it, so I can update it's count (times searched), or should I rather forget
that and do the counts in a custom reporting function/ sql query?

I am kind of worried that the Django database API is may not deal with all
these too gracefully. NB - I am not cool with tinkering with models
(especially not object relationships) too much when I have to maintain this
in a year or two.

I guess I am learning about proper database schema design.

PS - I know this is not a MySQL mailing list, but there are people here who
have solved the sort of problem I describe, in Django + MySQL.

Thanks.

-- 
Regards,
Sithembewena Lloyd Dube

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to 
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en.

Reply via email to