Performance in SQL Mobile with one big column that's not being selected
Posted
by Anthony Mastrean
on Stack Overflow
See other posts from Stack Overflow
or by Anthony Mastrean
Published on 2008-11-12T16:58:07Z
Indexed on
2010/05/23
2:20 UTC
Read the original article
Hit count: 344
I have a SQL Mobile database with one table. It has several columns with useful, often queried data and one column that stores a relatively large string per record (1000+ characters) that is not queried often.
Imagine this fake schema, the "lifeStory" field is the large one.
table1
String firstName
String lastName
String address
String lifeStory
A representative query would be
SELECT firstName, lastName, address FROM table1 WHERE firstName = :p1
Does anyone know of any performance concerns leaving that large, infrequently queried column in this table?
© Stack Overflow or respective owner
