Re: Varchar vs Nvarchar

"David Browne" <davidbaxterbrowne no potted meat@xxxxxxxxxxx> wrote in
message news:ODq7FGE9FHA.444@xxxxxxxxxxxxxxxxxxxxxxx
>
> I have to agree here. Although 7.6g is really not much, a database half
> that size is significantly easier to manage and will perform better
> automatically.

True. Smaller data means fewer data pages to read into memory when
retrieving rows, which means fewer I/O operations, which means better
performance. But the flip side is how long it might take to convert the
entire database... and if there's no performance problem already, it may not
be worthwhile.


--
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--



.

Relevant Pages

  • Re: Delphis weakness remains/creates Delphis weakness.
    ... What if somebody writes a database in delphi? ... Exactly <- performance problem right around the corner =D ... > client software. ...
    (alt.comp.lang.borland-delphi)
  • Re: Question about "PL/SQL lock timer" event in Statspack
    ... I am using Statspack to investigate a performance problem in my ... In a moment that the database doesn't present ... Senior Oracle DBA ...
    (comp.databases.oracle.server)
  • RE: Low speed shared database
    ... It could be something as simple as the virus checkers on the computers. ... Another performance problem can be fixed with a persistant connection. ... form open when the database does, ... Jerry Whittle, Microsoft Access MVP ...
    (microsoft.public.access.setupconfig)
  • Re: Question about "PL/SQL lock timer" event in Statspack
    ... time" is lower compared to the example where the database is performing ... I am using Statspack to investigate a performance problem in my ... these are the TOP 5 TIMED EVENTS: ...
    (comp.databases.oracle.server)
  • Re: Search is slow in Access 2003 vs Access 2000
    ... factor here giving you the performance problem. ... Start by working through Tony Toews' performance FAQ at: ... If I open the database in Access ... 2000 and do a search using the binoculars on the Company field (an ...
    (microsoft.public.access.forms)
Loading