Wednesday, March 28, 2012

how must i design table(s)

Hello,
i need a new table for a new picture gallery. But there is a problem
like that under the picture there is a view information and after all
views its value is updated. If i make it indexed update takes more
time and performance is also important for me, if i dont use indexed
listing takes more time.
Help me how must i design this table?It's difficult to make recommendations without your table DDL, queries and
what version of SQL Server you are using.
Updates to an indexed column incur overhead but it may be justified by data
retrieval performance. If performance is important to you, you'll need to
run performance tests on your hardware. For a write-intensive application
like this, also pay particular attention to configuration details like
separating transaction log from data, RAID 10 for data and write-caching
(with guaranteed persistence).
Hope this helps.
Dan Guzman
SQL Server MVP
<cirakbulent@.gmail.com> wrote in message
news:1173175276.632938.18040@.c51g2000cwc.googlegroups.com...
> Hello,
> i need a new table for a new picture gallery. But there is a problem
> like that under the picture there is a view information and after all
> views its value is updated. If i make it indexed update takes more
> time and performance is also important for me, if i dont use indexed
> listing takes more time.
> Help me how must i design this table?
>sql

No comments:

Post a Comment