Tìm kiếm hỗ trợ

Tránh các lừa đảo về hỗ trợ. Chúng tôi sẽ không bao giờ yêu cầu bạn gọi hoặc nhắn tin đến số điện thoại hoặc chia sẻ thông tin cá nhân. Vui lòng báo cáo hoạt động đáng ngờ bằng cách sử dụng tùy chọn "Báo cáo lạm dụng".

Learn More

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

  • 2 trả lời
  • 1 gặp vấn đề này
  • 59 lượt xem
  • Trả lời mới nhất được viết bởi cor-el

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?

Giải pháp được chọn

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

Đọc câu trả lời này trong ngữ cảnh 👍 0

Tất cả các câu trả lời (2)

more options

Giải pháp được chọn

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

more options

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