On Oct 15, 3:11 pm, onno <[EMAIL PROTECTED]> wrote: > Arn't stings slower against integers?
A datatype of varchar versus integer isn't what's going to slow you down. If you don't have an index on a column and you use that column in your predicate (i.e., where clause) you will end up doing a full table scan, e.g.: select * from foo where type = 1; select * from foo where type = 'FOO'; Both of those queries require a full table scan and perform equally bad. If you index the type column, both will perform equally well. Partial string matches will also use an index if available, at least in Postgres. E.g., select * from foo where type = 'F%'; --Uses 'type' index if available See the following: http://www.postgresql.org/docs/8.2/static/indexes.html Read that chapter if you're a little light on database expertise. It's very useful information. Hope that helps! doug. --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
