PDXpert PLM Software
On-line Help Guide
This help topic describes the current PDXpert PLM release. Earlier releases may be different. To view your release's version of this topic, open PDXpert and press the F1 key or select the Help menu.
Administrators open this window using Manage as administrator marked.The menu command is shown when the user's role has
The Index Status tool shows the status of indexed items (documents, parts, change forms) and file attachments.
There are two index functions, with different purposes:
A SQL Server database table index determines how fast a data table can be scanned to find a specific data record, and how fast it's linked to related records in other tables. These table indexes are used for item searches; making new items; opening existing records; running reports and transforms; and anything else that gets data from the SQL Server database.
The search engine index selects documents, parts, change forms and file attachments in response to an Item Explorer search request. This index only affects what text can be found using the Item Explorer; it has no impact on how fast it can be found. This index has no performance effect on creating or viewing items; processing change forms; running reports; or using transforms.
Although both indexes are automatically managed, you can use thebutton to rebuild the database table indexes and then update the search engine index.
After you click the Index Status tool – the indexing process continues to run on the server computer until it's finished.button, you can close the
Re-index during a quiet time:
- Rebuilding the database table indexes requires noticeable system resources.
- Until search engine indexing is finished, some items may not be shown in Item Explorer search results.
A typical computer indexes about 2000 items per minute, but indexing can be much faster or slower depending on many factors.
Database table index §
Maintain database performance by re-indexing at least once a year. More frequent re-indexing is normally not needed.
The Batch Importer tool can fragment database table indexes, particularly when importing items that have custom attributes. Re-index after you finish a large import project.
If frequent re-indexing noticeably improves performance, consider scheduling a task to regularly de-fragment the table indexes. If you're comfortable using Transact-SQL, search the web for sql server reorganize rebuild fragmented index
Search engine index §
Item index §
The search index is updated by the server computer's PDXpert Server service. The index service selects a new group of records from the index queue every few seconds.
When you save a record, it's added to the service's indexing queue. If there's nothing else in the queue, then indexing starts on the next index cycle.
After making or changing a data record, the record and all of its direct relationships are re-indexed; the indexed results may not be instantly available.
After changing a collection member, every item using that member must be re-indexed. If you edit a frequently-used member (for example, an item lifecycle name or unit of measure), then most items in the database may need re-indexing.
Server hardware, storage connection bandwidth, SQL Server edition, and transaction load have a big effect on index speed.
Item indexing is first-in, first-out. If the queue is working on other records, these are completed before new items are started. If a group of items is added to the queue, some items become searchable before others. A search may return a few — but probably not all — matching items, and then more may appear in a new search, until all have been indexed.
If the same item is added to the queue several times, then the system indexes the item once, and deletes the duplicate entries.
An item's indexed terms may include information about related items. For example, a change form may mention a part number that it released, and the change form may appear in that part's search results.
Adding, changing or removing a type's custom attribute definition adds all related items to the queue. Unlike standard attributes, a custom attribute cannot be optimized and needs more time to index. Indexing speed is directly related to the number of custom attributes multiplied by the number of items with those attributes.
File index §
File attachments are indexed using software components ("IFilters") installed on the server computer. There may be a noticeable delay before file indexing starts, and the filter service runs at a much slower speed than item indexing.
Adding a new file to an item automatically schedules the file for indexing. In normal operation, there's never a need to use thebutton.
Restoring a database PDXZ file automatically indexes all files. When you restore a database .BAK and separate library folder, and do not restore the contents of the Data\Filter folder, use the button.
Indexing speed and quality depend on file size, language/culture settings, source application, and IFilter capabilities. These capabilities may be affected by Microsoft Windows and .NET updates, as well as third-party plug-ins installed on the server computer.
Most IFilters are designed to extract normal text from files; only specialized IFilters can convert scanned images to usable text characters (OCR).
After installing or upgrading an IFilter, restart the server computer.
For simpler IFilters, such as the File Properties filter, results may be directly saved in the item index, not in the Data\Filter folder. If you assign a new IFilter to (for example) CAD files that previously used the File Properties filter, use the button to re-index these files.
An IFilter produces the same results each time a file is indexed. Previously-indexed results that have been saved in the Data\Filter folder are not re-indexed. In general, older files should be re-indexed only when an IFilter is changed or upgraded; for example, if the Windows default Reader Search Handler is replaced with a different PDF filter.
In the special case when a complete re-index of all library files is required, select one of these options to delete the Data\Filter folder contents:
Option A: Preferred for all systems.
On the PDXpert Server window, note the location of the current data directory.
Close the PDXpert Application Server window and all PDXpert clients.
Stop the PDXpert Server service and, if asked, the PDXpert Filter Service.
Delete all files in the server data directory's Data\Filter folder.
Do not make any changes in other data directory folders.
Restart the server computer. Do not simply restart the PDXpert Server service.
After Windows restarts, open a PDXpert client to re-index all files using thebutton.
Option B: Acceptable for smaller systems using the .PDXZ backup format.
Resetting the system deletes the content of all folders, including the Data\Filter folder.
Help Guide Contents [as PDF]
- 0001. Welcome!
- 0002. Help styles
- 0100. PDXpert Application Server
- 0101. Server overview
- 0200. How to...
- 0300. Console reference
- 0400. How to start the PDXpert client
- 0500. PDXpert introduction
- 0600. How to set up PDXpert
- 0700. How to use the Item Explorer
- 0800. How to use the Collection Explorer
- 0900. How to work with documents
- 0901. How to work with documents
- 1000. How to start a document
- 1003. Fill in the new document
- 1004. Add or remove references
- 1005. Start and update a task
- 1006. Save your document
- 1007. Remove your document
- 1008. Release your document
- 1009. Manage a released document
- 1010. Revise a released document
- 1011. Cancel a released document
- 1100. How to work with parts
- 1101. How to work with parts
- 1200. How to start a part
- 1203. Fill in the new part
- 1204. Add, modify or remove BOM parts
- 1205. Import a CAD BOM
- 1206. Add or remove approved sources
- 1207. Add or remove references
- 1208. Add or remove materials
- 1209. Start and update a task
- 1210. Save your part
- 1211. Remove your part
- 1212. Release your part
- 1213. Revise a released part
- 1214. Manage a released part
- 1215. Cancel a released part
- 1300. How to revise multiple markups
- 1400. How to work with change forms
- 1401. Processing a change
- 1500. How to start a change form
- 1503. Start and update a task
- 1504. Analyze a submitted change
- 1505. Fix change form routing errors
- 1506. Remove your change form
- 1507. Review a routed change
- 1508. Resolve an on-hold change
- 1509. Analyze an accepted change
- 1510. Use a released change
- 1511. View a completed change
- 1512. Analyze a stopped change
- 1513. View a rejected change
- 1514. Remove a canceled change
- 1515. Return a submitted change
- 1600. How to work with file attachments
- 1700. How to report, import & export
- 1701. Run a report
- 1702. Export a PDX package
- 1703. Use the DataGrid
- 1704. Use the Report/Export Wizard
- 1800. Import & update items
- 1801. Use the Batch Importer
- 1802. Item Master import
- 1803. Iteration-level relational imports
- 1804. Bill of materials import
- 1805. References import
- 1806. Revision files import
- 1807. Sources import
- 1808. Item-level relational imports
- 1809. Item files & links import
- 1810. Materials import
- 1811. Groups collection import
- 1812. Materials collection import
- 1813. Organizations collection import
- 1814. Persons collection import
- 1815. Custom collection import
- 1900. View & export via ODBC
- 1901. View database objects
- 1902. Create an ODBC connection
- 1903. ItemViews reference
- 1904. ReferencePairViews reference
- 1905. SourcePairViews reference
- 1906. SourceItemMasterView reference
- 1907. StructurePairViews reference
- 1908. ChangeViews reference
- 1909. ChangePairViews reference
- 1910. FilePairMasterView reference
- 2000. How to do other tasks
- 2100. Menu reference
- 2200. Document reference
- 2300. Part reference
- 2400. Change Form reference
- 2500. System Rules reference
- 2501. System Rules tool
- 2502. General: Copy files to snapshot
- 2503. General: Copy previous tasks
- 2504. General: Item uniqueness definition
- 2505. General: Reviewer comment required
- 2506. Default File Access
- 2507. Password Policy
- 2508. References Tabs
- 2509. BOM: Limit part to one row
- 2510. BOM: Lock part unit of measure
- 2511. BOM: Allow partner parts
- 2600. Collections reference
- 2601. Managing collections
- 2602. Custom attributes
- 2700. Places/Organizations/Persons
- 2800. General
- 2900. Documents
- 3000. Parts
- 3100. Changes
- 3108. Custom collections
- 3200. Other reference topics
- 3300. Software licenses & legal notices