search

IBSurgeon / lucene_udr

Lucene FTS UDR
51 stars 6 forks source link

in production #1

Closed RDP1974 closed 2 years ago

RDP1974 commented 2 years ago

hi, please can I ask if you have real production software with this extension? it is reliable, safe, scalable? thanks

sim1984 commented 2 years ago

It is used in 50Gb database with addresses search, very fast, 30ms vs 10sec of usual search. Approximately 50 users are working on the address database, but there are no updates. Our extension does not do real-time index updates. All index updates are deferred. We can do an index update either through a full rebuild, or according to the change log with the accumulation of changes in triggers and launching the update procedure from these logs on a schedule.

sim1984 commented 2 years ago

Please do not write questions not related to bugs and improvements in issue. There is a channel for discussion https://t.me/+2bn6m3vWV7thZTBi or support@ib-aid.com

RDP1974 commented 2 years ago

Hello, how much time is needed to rebuild the words index? Approximately thanks

Da: Simonov Denis @.> Inviato: martedì 5 luglio 2022 11:49 A: IBSurgeon/lucene_udr @.> Cc: Roberto Della Pasqua @.>; Author @.> Oggetto: Re: [IBSurgeon/lucene_udr] in production (Issue #1)

It is used in 50Gb database with addresses search, very fast, 30ms vs 10sec of usual search. Approximately 50 users are working on the address database, but there are no updates. Our extension does not do real-time index updates. All index updates are deferred. We can do an index update either through a full rebuild, or according to the change log with the accumulation of changes in triggers and launching the update procedure from these logs on a schedule.

- Reply to this email directly, view it on GitHubhttps://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FIBSurgeon%2Flucene_udr%2Fissues%2F1%23issuecomment-1174857668&data=05%7C01%7C%7Cc3e9d7f611154f3db8bd08da5e6b8da1%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637926113263950620%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=O%2BsNmTkucrElBziTmR4pLkLavweFdQIrtbJOEzajDUs%3D&reserved=0, or unsubscribehttps://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FASJYYI2CCN6T7FHXJMAKMW3VSQAHZANCNFSM52VQSQBQ&data=05%7C01%7C%7Cc3e9d7f611154f3db8bd08da5e6b8da1%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637926113263950620%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=OSTNIb53OwIG4iRkWQno4l9uF0S3nzSkxy6MKuUGlGY%3D&reserved=0. You are receiving this because you authored the thread.Message ID: @.**@.>>