Full Text: FASTEST update

Hi,
My users must be able to do a full text search, and add items to the
database if they aren't in yet. But once an item is added, in a lot of cases
they need it directly after it.
But when they search for it after the insert, the article isn't found... It
takes at least 10 seconds before it's found in the full text index...
Is there a way to speed it up? That speed is really very important for my
applciation! I use now "Change tracking" and "Update Index in background".
Should I use incremential population? Without the "update index in
background"? When I don't use "update index in background": does this mean
that it will update the index immediately in the mean-thread (and will be
faster) or that it won't update at all?
Thanks a lot in advance,
Pieter
Pieter wrote on Thu, 9 Feb 2006 12:27:41 +0100:

> Hi,
> My users must be able to do a full text search, and add items to the
> database if they aren't in yet. But once an item is added, in a lot of
> cases they need it directly after it.
> But when they search for it after the insert, the article isn't found...
> It takes at least 10 seconds before it's found in the full text index...
> Is there a way to speed it up? That speed is really very important for my
> applciation! I use now "Change tracking" and "Update Index in background".
> Should I use incremential population? Without the "update index in
> background"? When I don't use "update index in background": does this mean
> that it will update the index immediately in the mean-thread (and will be
> faster) or that it won't update at all?
I don't think you'll get it faster than using Change Tracking with Update
Index In Background. Incremental is used when you want to create all the new
entries since the last full/incremental population, where you don't want
near real-time updates. If you disable Change Tracking then you will have to
schedule Incremental and/or Full populations yourself.
Dan
|||10 seconds is pretty good, especially if your content is binary.
Note that change tracking with update index in background provides near real
time indexing (10s or less). When you don't use this option the changes are
logged in a file and when you issue an update index they are indexed.
Incremental means that each row is retrieved and if it has been
modified/deleted/inserted it is reindexed. This can take as long or longer
than a full population.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Pieter" <pietercoucke@.hotmail.com> wrote in message
news:OlyaZvWLGHA.3276@.TK2MSFTNGP09.phx.gbl...
> Hi,
> My users must be able to do a full text search, and add items to the
> database if they aren't in yet. But once an item is added, in a lot of
> cases they need it directly after it.
> But when they search for it after the insert, the article isn't found...
> It takes at least 10 seconds before it's found in the full text index...
> Is there a way to speed it up? That speed is really very important for my
> applciation! I use now "Change tracking" and "Update Index in background".
> Should I use incremential population? Without the "update index in
> background"? When I don't use "update index in background": does this mean
> that it will update the index immediately in the mean-thread (and will be
> faster) or that it won't update at all?
> Thanks a lot in advance,
> Pieter
>
>

Full Screen in Report Manager?

Hi all...
I'm curious if there is a way to default to "full screen" mode when a
user first views a report through report manager. The users here can
click the arrows on the right side and thus make the "header" of the
page collapse, but is there a way to default to that so that the users
don't have to click the arrows?
I had read something about the option to collapse the parameter portion
of the report coming with SP1, which we just installed, but haven't
been able pinpoint how to do it.
We've also given users to ability to access reports via our intranet by
physically typing in the address to our intranet. That address
redirects to the report server - wondering if this may make a
difference in the ability to default to full screen.
Any help is appreciated.
Thanks,
MattIn the link you use to call the report add in &rc:Toolbar=false and
possibly &rc:Parameters=false to remove everything.
ie
src="http://myreportserver/ReportServer?%2fReportfolder%2fParameter&rc%3aParameters=false&rc:LinkTarget=_self&rc:ToolBar=false"|||Thanks for the info! I know that the answer to my problem is in there
somewhere, but when I copy what you have after
"myreportserver/ReportServer" in the link above and add it to the URL
that my project points to, I'm being asked for login/password, and that
shouldn't be happening?
Am I able to take parts of what you wrote above to make the parameters
not be viewable? Sorry to wollow in the details of this as I'm guessing
it's not all that complicated, but it's the first time I've given this
a shot, so thanks for your patience.
Matt|||Yes!
take your regular link and add the pieces you want afterward.
&rc:Parameters=false
&rc:ToolBar=false
&rc:LinkTarget=_blank (or _top or _self...)
You should be able to just tack them on after what you already have.
Ches|||Yes!
take your regular link and add the pieces you want afterward.
&rc:Parameters=false
&rc:ToolBar=false
&rc:LinkTarget=_blank (or _top or _self...)
You should be able to just tack them on after what you already have.
Ches|||Thanks once again for the help.
When I add the piece to suppress parameters and/or the toolbar, I end
up with this link as what is entered for the TargetURL for the
solution:
http://servername/ReportServer&rc:ToolBar=false
When I hit F5 to push the changes to the server, I end up getting the
following:
"A connection could not be made to the report server
http://servername/ReportServer&rc:ToolBar=false"
Any idea what I'm missing or doing wrong here? Do I need a "?" directly
after "reportserver"....this is one of those things that is a small
problem, but the annoyance that it is causing is growing!!
Again, thanks for the help...
Matt

Full Screen in Report Manager

Hi all....

I'm curious if there is a way to default to "full screen" mode when a user first views a report through report manager. The users here can click the arrows on the right side and thus make the "header" of the page collapse, but is there a way to default to that so that the users don't have to click the arrows?

We've also given users to ability to access reports via our intranet by physically typing in the address to our intranet. That address redirects to the report server - wondering if this may make a difference in the ability to default to full screen.

Any help is appreciated.
Thanks,
MattHi Matt,
We too are trying to achieve a "full screen" view when a user clicks a hyper-link from our intranet.
I have browsed the forums expecting the answer to be somewhere in the Report properites but have had no joy. Can anyone please help ?
Cheers
Smeganb|||Hi Matt,

I have been investigating this further and can offer the following:

Using the url

http://<<localhost>>/Reports/Pages/Report.aspx?ItemPath=<<ReportName>>

produces a report with all the paraphernalia assocaited with the Report manager (good though it is i do not want users to be overloaded with superfluous information.

If you point the user to the url

http://<<localhost>>/ReportServer/Pages/Report.aspx?<<ReportName>>&rs:Command=Render

you get a report displayed in a new IE window without the paraphernalia. But that's not all because you can aso use a myriad of other switches to determine what is or is not displayed.E.g.

&rc:Toolbar=false removes the Report Viewer toolbar
&rc:Toolbar=true displays it

I hope this helps

Cheers

Rich

Full Screen in Report Manager

Hi all....

I'm curious if there is a way to default to "full screen" mode when a user first views a report through report manager. The users here can click the arrows on the right side and thus make the "header" of the page collapse, but is there a way to default to that so that the users don't have to click the arrows?

We've also given users to ability to access reports via our intranet by physically typing in the address to our intranet. That address redirects to the report server - wondering if this may make a difference in the ability to default to full screen.

Any help is appreciated.
Thanks,
MattHi Matt,
We too are trying to achieve a "full screen" view when a user clicks a hyper-link from our intranet.
I have browsed the forums expecting the answer to be somewhere in the Report properites but have had no joy. Can anyone please help ?
Cheers
Smeganb|||Hi Matt,

I have been investigating this further and can offer the following:

Using the url

http://<<localhost>>/Reports/Pages/Report.aspx?ItemPath=<<ReportName>>

produces a report with all the paraphernalia assocaited with the Report manager (good though it is i do not want users to be overloaded with superfluous information.

If you point the user to the url

http://<<localhost>>/ReportServer/Pages/Report.aspx?<<ReportName>>&rs:Command=Render

you get a report displayed in a new IE window without the paraphernalia. But that's not all because you can aso use a myriad of other switches to determine what is or is not displayed.E.g.

&rc:Toolbar=false removes the Report Viewer toolbar
&rc:Toolbar=true displays it

I hope this helps

Cheers

Rich

Full Screen in Report Manager

Hi all....

I'm curious if there is a way to default to "full screen" mode when a user first views a report through report manager. The users here can click the arrows on the right side and thus make the "header" of the page collapse, but is there a way to default to that so that the users don't have to click the arrows?

We've also given users to ability to access reports via our intranet by physically typing in the address to our intranet. That address redirects to the report server - wondering if this may make a difference in the ability to default to full screen.

Any help is appreciated.
Thanks,
MattHi Matt,
We too are trying to achieve a "full screen" view when a user clicks a hyper-link from our intranet.
I have browsed the forums expecting the answer to be somewhere in the Report properites but have had no joy. Can anyone please help ?
Cheers
Smeganb|||Hi Matt,

I have been investigating this further and can offer the following:

Using the url

http://<<localhost>>/Reports/Pages/Report.aspx?ItemPath=<<ReportName>>

produces a report with all the paraphernalia assocaited with the Report manager (good though it is i do not want users to be overloaded with superfluous information.

If you point the user to the url

http://<<localhost>>/ReportServer/Pages/Report.aspx?<<ReportName>>&rs:Command=Render

you get a report displayed in a new IE window without the paraphernalia. But that's not all because you can aso use a myriad of other switches to determine what is or is not displayed.E.g.

&rc:Toolbar=false removes the Report Viewer toolbar
&rc:Toolbar=true displays it

I hope this helps

Cheers

Rich

Full backup 'on-line'

Hello everyone, can you describe me, how SQL Server makes full backup of dat
abase when users are inserting and updating data in tables. Is it possible m
ake backup 'on-line' ?
Thank you
RP.> Hello everyone, can you describe me, how SQL Server makes full backup of
database when users are inserting and updating data in tables. Is it
possible make backup 'on-line' ?
This is from an article at
http://activeanswers.compaq.com/aa_...25/1/38758.pdf:
SQL Server 2000 backup does not delay normal database activity. It backs up
the database files as fast as possible without regard to logical
inconsistencies introduced by active transactions. It then captures the
transaction log written during the time the data was being backed up. During
the restore, the data is restored first, and then the transaction log is
applied to make the database logically consistent. The result is that online
backups performed during normal operations have a minimal effect on
transaction throughput, while maintaining high backup performance.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com|||It is very interesting article, I maybe asked a little wrong.
I try describe my trouble:
If some backup script (BACKUP DATABASE db TO …) is started during transact
ion (inserting data in tables), I thing, the saved database with transaction
log can’t be in logical nconsistence and I will not be able restore datab
ase.
Are there only two ways how to resolve it - worm and hot backup?
Or can I do it by any T-SQL script?
Thanks
RP|||Because of the way SQL Server backs up the database and log, as described by
Dejan, all the transactions up to the time that the log is backed up will be
in the backup. All transaction that have started but have not been completed
will be rolled back as the transaction log is applied to the database during
the restore process, all the completed transactions will be rolled forward.
This ensures that the database is always consistent.
Jacco Schalkwijk
SQL Server MVP
"RP" <anonymous@.discussions.microsoft.com> wrote in message
news:234D6D56-DFEB-425E-9AB2-C7EBE4DB324B@.microsoft.com...
> It is very interesting article, I maybe asked a little wrong.
> I try describe my trouble:
> If some backup script (BACKUP DATABASE db TO .) is started during
transaction (inserting data in tables), I thing, the saved database with
transaction log can't be in logical nconsistence and I will not be able
restore database.
> Are there only two ways how to resolve it - worm and hot backup?
> Or can I do it by any T-SQL script?
> Thanks
> RP
>|||Thaks for explanation.

Full backup 'on-line'

Hello everyone, can you describe me, how SQL Server makes full backup of database when users are inserting and updating data in tables. Is it possible make backup 'on-line'
Thank yo
RP.> Hello everyone, can you describe me, how SQL Server makes full backup of
database when users are inserting and updating data in tables. Is it
possible make backup 'on-line' ?
This is from an article at
http://activeanswers.compaq.com/aa_downloads/6/100/225/1/38758.pdf:
SQL Server 2000 backup does not delay normal database activity. It backs up
the database files as fast as possible without regard to logical
inconsistencies introduced by active transactions. It then captures the
transaction log written during the time the data was being backed up. During
the restore, the data is restored first, and then the transaction log is
applied to make the database logically consistent. The result is that online
backups performed during normal operations have a minimal effect on
transaction throughput, while maintaining high backup performance.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com|||It is very interesting article, I maybe asked a little wrong
I try describe my trouble
If some backup script (BACKUP DATABASE db TO â?¦) is started during transaction (inserting data in tables), I thing, the saved database with transaction log canâ't be in logical nconsistence and I will not be able restore database
Are there only two ways how to resolve it - worm and hot backup
Or can I do it by any T-SQL script
Thank
R|||Because of the way SQL Server backs up the database and log, as described by
Dejan, all the transactions up to the time that the log is backed up will be
in the backup. All transaction that have started but have not been completed
will be rolled back as the transaction log is applied to the database during
the restore process, all the completed transactions will be rolled forward.
This ensures that the database is always consistent.
--
Jacco Schalkwijk
SQL Server MVP
"RP" <anonymous@.discussions.microsoft.com> wrote in message
news:234D6D56-DFEB-425E-9AB2-C7EBE4DB324B@.microsoft.com...
> It is very interesting article, I maybe asked a little wrong.
> I try describe my trouble:
> If some backup script (BACKUP DATABASE db TO .) is started during
transaction (inserting data in tables), I thing, the saved database with
transaction log can't be in logical nconsistence and I will not be able
restore database.
> Are there only two ways how to resolve it - worm and hot backup?
> Or can I do it by any T-SQL script?
> Thanks
> RP
>|||Thaks for explanation.