Where did you install Firefox from? Help Mozilla uncover 3rd party websites that offer problematic Firefox installation by taking part in our campaign. There will be swag, and you'll be featured in our blog if you manage to report at least 10 valid reports!

Avatar for Username

Przeszukaj pomoc

Unikaj oszustw związanych z pomocą.Nigdy nie będziemy prosić Cię o dzwonienie na numer telefonu, wysyłanie SMS-ów ani o udostępnianie danych osobowych. Zgłoś podejrzaną aktywność, korzystając z opcji „Zgłoś nadużycie”.

Learn More

Wątek został zarchiwizowany. Jeśli potrzebujesz pomocy, zadaj nowe pytanie.

Is this how you Re-index places.sqlite, for faster performance?

  • 2 odpowiedzi
  • 1 osoba ma ten problem
  • 2 wyświetlenia
  • Ostatnia odpowiedź od cor-el

sludge7051-x
sludge7051-x
more options

Get SQLite Manager . . . https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/

SQLite Manager / Tables / moz_places

Right-click on moz_places / Reindex Table / Yes

  • * * * * * * * * * * * * * * * * * * * * * * * *

Per this page . . . https://support.mozilla.org/en-US/questions/969977

The minimum file size of the places.sqlite file is 10 MB, and Firefox increases this file in 10 MB chunks when necessary (its size is never reduced when deleting history or bookmarks). This is done for performance issues caused by fragmentation.

  • * * * * * * * * * * * * * * * * * * * * * * * *

. . . My places.sqlite is 10,240 KB (10 MB)

  • * * * * * * * * * * * * * * * * * * * * * * * *

I was trying to figure out what:

Index / Reindex Index . . . does

I found that it only does something with this:

Are you sure you want to perform the following operation(s): REINDEX "main"."moz_annos_placeattributeindex" SQL: REINDEX "main"."moz_annos_placeattributeindex"

. . . what does Reindex Index do?

Get SQLite Manager . . . https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/ SQLite Manager / Tables / moz_places Right-click on moz_places / Reindex Table / Yes * * * * * * * * * * * * * * * * * * * * * * * * * Per this page . . . https://support.mozilla.org/en-US/questions/969977 The minimum file size of the places.sqlite file is 10 MB, and Firefox increases this file in 10 MB chunks when necessary (its size is never reduced when deleting history or bookmarks). This is done for performance issues caused by fragmentation. * * * * * * * * * * * * * * * * * * * * * * * * * . . . My places.sqlite is 10,240 KB (10 MB) * * * * * * * * * * * * * * * * * * * * * * * * * I was trying to figure out what: Index / Reindex Index . . . does I found that it only does something with this: Are you sure you want to perform the following operation(s): REINDEX "main"."moz_annos_placeattributeindex" SQL: REINDEX "main"."moz_annos_placeattributeindex" . . . what does Reindex Index do?

Wybrane rozwiązanie

Normally it is already indexed, however this helps corrupted indexed places.sqlite files afaik, however you can also ask the add on developer.

Przeczytaj tę odpowiedź w całym kontekście 👍 0

Wszystkie odpowiedzi (2)

guigs
guigs
more options

Wybrane rozwiązanie

Normally it is already indexed, however this helps corrupted indexed places.sqlite files afaik, however you can also ask the add on developer.

cor-el
cor-el
  • Moderator
  • Top 10 Contributor
more options

Best is to use the Places Maintenance extension to do such maintenance