Handling Slow Access and Crashes - Revision history

PubGizmoSysop at 01:14, 13 May 2025

2025-05-13T01:14:52Z

← Older revision		Revision as of 21:14, 12 May 2025
Line 18:		Line 18:

	==== "Expense" ====		==== "Expense" ====
	We talk about the factors of data volume and computational strain in terms of "expense." It is ''expensive'', it terms of computational power and data mobility to run a hard calc on a ton of data.		We talk about the factors of data volume and computational strain in terms of "expense." It is ''expensive'', in terms of computational power and data mobility, to run a hard calc on a ton of data.

	Imagine a briskly selling book, with many sales records. Each record is a piece of data, and when you open a Royalty Statement, all that data has to be collated, and then the royalty calculations must be run. A book with a 1000 sales involves 10 times more data than one with 100 sales.		Imagine a briskly selling book, with many sales records. Each record is a piece of data, and when you open a Royalty Statement, all that data has to be collated, and then the royalty calculations must be run. A book with a 1000 sales involves 10 times more data than one with 100 sales.
Line 49:		Line 49:
	# running a complex calculation		# running a complex calculation
	# attempting to fetch a large volume of data from the server to display, or to calculate		# attempting to fetch a large volume of data from the server to display, or to calculate
	# struggling ~~the~~ negotiate a bad network connection		# struggling to negotiate a bad network connection
	# impeded by your computer's speed		# impeded by your computer's speed
	# struggling with a heavy server load (unlikely)		# struggling with a heavy server load (unlikely)
Line 64:		Line 64:
	* Using the Reporter with many of record selected, or covering a large span of time		* Using the Reporter with many of record selected, or covering a large span of time
	* Viewing records in List View, especially Royalties if the amount column is toggled on (PG must calculate royalties for all the statements in the view, which invokes hundreds or even thousands of calculations).		* Viewing records in List View, especially Royalties if the amount column is toggled on (PG must calculate royalties for all the statements in the view, which invokes hundreds or even thousands of calculations).
			If some records are predictably quick, and others are predictably slow, e.g., "I know when I open this Royalty Statement it always takes a while," you know that things are operating normally (even if waiting sucks), because there's a consistency to the slowness.

	== What to Do ==		== What to Do ==

PubGizmoSysop: /* Help! PubGizmo/FileMaker Pro is crashing! */

2025-05-01T16:41:41Z

Help! PubGizmo/FileMaker Pro is crashing!

@@ Line 1: / Line 1: @@
-== Help! PubGizmo/FileMaker Pro is crashing! ==
+== Help! PubGizmo/FileMaker Pro is Slow/Crashing! ==
-This is a frustrating and time-consuming occurrence, and we are sorry you are experiencing it. There can be a variety of causes, some of which are us, some of which are you, and some to chalk up to the mysteries of computers and networks.
+Both slowness and crashing are frustrating occurrences, and we are sorry for these experiences. There can be a variety of causes, some of which are us, some of which are you, and some to chalk up to the mysteries of computers and networks.
 == Is it a Crash or a Freeze? ==
-Firstly, we should distinguish between a crash and a freeze. These are different events, and require different handling.
+We should distinguish between a crash and a freeze. These are different events, and require different handling.
 === Crash ===
@@ Line 44: / Line 76: @@
 ===== Computer Problem =====
-Do other programs also crash? If yes, then the problem lies with your computer, either the hardware, or your operating system. Windows is more prone to this kind of issue that macOS. The best bet with either is a complete wipe and reinstall of your computer; it's not a trivial task, but it can yield significant improvements, not just in terms of stability, but also computer performance. You can find on various tech sites information on how to perform a wipe and reinstall. The most important step is to back up your data, since the "wipe" part involves deleting everything on your computer.
+Do other programs also crash? If yes, then the problem lies with your computer, either the hardware or your operating system. Windows is more prone to this kind of issue that macOS. The best bet with either is a complete wipe and reinstall of your computer; it's not a trivial task, but it can yield significant improvements, not just in terms of stability, but also computer performance. You can find on various tech sites information on how to perform a wipe and reinstall. The most important step is to back up your data, since the "wipe" part involves deleting everything on your computer.
-If your problems survive a wipe/reinstall, it could be an issue with your computer hardware. This is best diagnosed by a professional.
+If your problems survive a wipe/reinstall, it could be an issue with your computer hardware, for example, bad memory, a failing hard disk, overheating. This is best diagnosed by a professional.
 ===== FileMaker Pro Application Problem =====
@@ Line 69: / Line 101: @@
 == Improvements Coming ==
-We have in our PubGizmo development plan a big update in the works that will cache sales data, instead of reading each sales record individually. This will yield a major performance improvement. Stand by for updates!
+We have in our PubGizmo development plan a big update in the works that will cache sales data, instead of reading each sales record individually. This will yield a major performance improvement. Stay turned for updates.

PubGizmoSysop: PubGizmoSysop moved page Handling Crashes to Handling Slow Access and Crashes without leaving a redirect: added slowdowns

2025-05-01T15:55:40Z

PubGizmoSysop moved page Handling Crashes to Handling Slow Access and Crashes without leaving a redirect: added slowdowns

← Older revision	Revision as of 11:55, 1 May 2025
(No difference)

PubGizmoSysop at 15:53, 1 May 2025

2025-05-01T15:53:04Z

← Older revision		Revision as of 11:53, 1 May 2025
Line 58:		Line 58:
	===== Poor Network Connection =====		===== Poor Network Connection =====
	If your internet is slow, access to PubGizmo will be slow. You can check your speed by going to [https://speedtest.net speedtest.net] and running a test. Faster is better, but at a minimum your up and down speeds should exceed 10 Mbps. Either or both of your internet provider speed or your network connection (e.g., on WiFi, but weak signal) can impede network traffic. If you rectify these issues, things may improve.		If your internet is slow, access to PubGizmo will be slow. You can check your speed by going to [https://speedtest.net speedtest.net] and running a test. Faster is better, but at a minimum your up and down speeds should exceed 10 Mbps. Either or both of your internet provider speed or your network connection (e.g., on WiFi, but weak signal) can impede network traffic. If you rectify these issues, things may improve.

			====== Are You Far Away? ======
			Wait, are you away, connecting from somewhere other than your press's location? Your speed/freeze issue may be due to network latency caused by distance. The physical server that hosts your solution is optimized for your press's physical location; we have two servers currently, and they are both in North America (Toronto and Vancouver), so if you're in Frankfurt, you are far away, and it takes longer for data to travel between your location and the server.

	===== Slow Computer =====		===== Slow Computer =====

PubGizmoSysop at 18:40, 30 April 2025

2025-04-30T18:40:00Z

← Older revision		Revision as of 14:40, 30 April 2025
Line 10:		Line 10:
	On a Mac, you'll usually receive a dialogue that tells you FileMaker Pro has crashed, with a few options: re-open, report the problem to Apple, or cancel. If you look at the [https://support.apple.com/en-ca/guide/mac-help/mh35859/mac Dock], the icon is gone, or, if you keep the icon in the Dock, there's no black dot below the icon to indicate it's running.		On a Mac, you'll usually receive a dialogue that tells you FileMaker Pro has crashed, with a few options: re-open, report the problem to Apple, or cancel. If you look at the [https://support.apple.com/en-ca/guide/mac-help/mh35859/mac Dock], the icon is gone, or, if you keep the icon in the Dock, there's no black dot below the icon to indicate it's running.

	On Windows, it no longer appears on the [https://support.microsoft.com/en-us/windows/how-to-use-the-taskbar-in-windows-0657a50f-0cc7-dbfd-ae6b-05020b195b07#:~:text=Typically%2C%20the%20taskbar%20is%20at,the%20top%20of%20the%20desktop. Taskbar]. If you look at the [[wikihow:Open-Windows-Task-Manager#:~:text=Press%20Ctrl%20%2B%20Shift%20%2B%20Esc%20to,and%20select%20%22Task%20Manager.%22\|Task Manager]], FileMaker does not appear.		On Windows, it no longer appears on the [https://support.microsoft.com/en-us/windows/how-to-use-the-taskbar-in-windows-0657a50f-0cc7-dbfd-ae6b-05020b195b07#:~:text=Typically%2C%20the%20taskbar%20is%20at,the%20top%20of%20the%20desktop. Taskbar]. If you look at the [[wikihow:Open-Windows-Task-Manager#:~:text=Press%20Ctrl%20%2B%20Shift%20%2B%20Esc%20to,and%20select%20%22Task%20Manager.%22\|Task Manager]], FileMaker does not appear. Note that a message indicating FileMaker has stopped responding could be crash, but it could also be a freeze, per below.

	=== Freeze ===		=== Freeze ===
	If FileMaker Pro is still running but unresponsive, it has frozen or stalled. There's a good chance it's still alive, but it has stalled, possibly because it is:		If FileMaker Pro is still running but unresponsive, it has frozen or stalled. There's a good chance it's still alive, but it has stalled, or is hesitating, possibly because it is:

	# ~~trying to run~~ a complex calculation		# running a complex calculation
	# attempting to fetch a large volume of data from the server to display, or to calculate		# attempting to fetch a large volume of data from the server to display, or to calculate
	# struggling the negotiate a bad network connection		# struggling the negotiate a bad network connection
Line 22:		Line 22:

	==== Wait it Out ====		==== Wait it Out ====
	In this situation, you may just have to wait for PG to yield data and update – give it a chance to complete its processes, and your results will appear. It can take many seconds, or even many minutes, in extreme cases, to respond.		In this situation, you may just have to wait for PG to yield data and update – give it a chance to complete its processes, and your results will appear. It can take many seconds, or even many minutes, in extreme cases, to respond. Take a breath, take a break, make a cup of tea.

	===== Data Volume and/or Complexity =====		===== Data Volume and/or Complexity =====
Line 44:		Line 44:

	===== Computer Problem =====		===== Computer Problem =====
	Do other programs also crash? If yes, then the problem lies with your computer, either the hardware, or your operating system. Windows is more prone to this kind of issue that macOS. The best bet with either is a complete wipe and reinstall of your computer; it's not a trivial task, but it can yield significant improvements, not just in terms of ~~crashing~~, but also computer performance. You can find on various tech sites information on how to perform a wipe and reinstall. The most important step is to back up your data, since the "wipe" part involves deleting everything on your computer.		Do other programs also crash? If yes, then the problem lies with your computer, either the hardware, or your operating system. Windows is more prone to this kind of issue that macOS. The best bet with either is a complete wipe and reinstall of your computer; it's not a trivial task, but it can yield significant improvements, not just in terms of stability, but also computer performance. You can find on various tech sites information on how to perform a wipe and reinstall. The most important step is to back up your data, since the "wipe" part involves deleting everything on your computer.

	If your problems survive a wipe/reinstall, it could be an issue with your computer hardware. This is best diagnosed by a professional.		If your problems survive a wipe/reinstall, it could be an issue with your computer hardware. This is best diagnosed by a professional.
Line 60:		Line 60:

	===== Slow Computer =====		===== Slow Computer =====
	An old computer or a computer problem (corrupt OS) can impede access to PubGizmo.		An old computer or a computer problem (corrupt OS, see above under "Computer Problem") can impede access to PubGizmo.

	==== Some Records or Reports ====		==== Some Records or Reports ====

PubGizmoSysop: /* Is it a Crash or a Freeze/Stall? */

2025-04-30T18:34:22Z

Is it a Crash or a Freeze/Stall?

← Older revision		Revision as of 14:34, 30 April 2025
Line 2:		Line 2:
	This is a frustrating and time-consuming occurrence, and we are sorry you are experiencing it. There can be a variety of causes, some of which are us, some of which are you, and some to chalk up to the mysteries of computers and networks.		This is a frustrating and time-consuming occurrence, and we are sorry you are experiencing it. There can be a variety of causes, some of which are us, some of which are you, and some to chalk up to the mysteries of computers and networks.

	== Is it a Crash or a Freeze~~/Stall~~? ==		== Is it a Crash or a Freeze? ==
	Firstly, we should distinguish between a crash and a freeze. These are different events, and require different handling.		Firstly, we should distinguish between a crash and a freeze. These are different events, and require different handling.

Line 44:		Line 44:

	===== Computer Problem =====		===== Computer Problem =====
	Do other programs also crash? If yes, then the problem lies with your computer, either the hardware, or your operating system. Windows is more prone to this kind of issue that macOS. The best bet with either is a complete wipe and reinstall of your computer; it's not a trivial task, but it can yield significant improvements, not just in terms of crashing, but also computer ~~speed~~. You can ~~search for~~ information on how to perform a wipe and reinstall. The most important step is to back up your data, since the "wipe" part involves deleting everything on your computer.		Do other programs also crash? If yes, then the problem lies with your computer, either the hardware, or your operating system. Windows is more prone to this kind of issue that macOS. The best bet with either is a complete wipe and reinstall of your computer; it's not a trivial task, but it can yield significant improvements, not just in terms of crashing, but also computer performance. You can find on various tech sites information on how to perform a wipe and reinstall. The most important step is to back up your data, since the "wipe" part involves deleting everything on your computer.

	If your problems survive a wipe/reinstall, it could be an issue with your computer hardware. This is best diagnosed by a professional.		If your problems survive a wipe/reinstall, it could be an issue with your computer hardware. This is best diagnosed by a professional.
Line 57:		Line 57:

	===== Poor Network Connection =====		===== Poor Network Connection =====
	If your internet is slow, access to PubGizmo will be slow. You can check your speed by going to [https://speedtest.net speedtest.net] and running a test. Faster is better, but at a minimum your up and down speeds should exceed 10 Mbps. ~~Your~~ internet speed or your network connection (e.g., on WiFi, but weak signal) can impede network traffic. If you rectify these issues, things may improve.		If your internet is slow, access to PubGizmo will be slow. You can check your speed by going to [https://speedtest.net speedtest.net] and running a test. Faster is better, but at a minimum your up and down speeds should exceed 10 Mbps. Either or both of your internet provider speed or your network connection (e.g., on WiFi, but weak signal) can impede network traffic. If you rectify these issues, things may improve.

	===== Slow Computer =====		===== Slow Computer =====
	An old computer or a computer problem (corrupt OS) can impede access to PubGizmo.		An old computer or a computer problem (corrupt OS) can impede access to PubGizmo.

			==== Some Records or Reports ====
			Big sellers, or contracts with complicated clauses (escalation), or, worse-still, combinations of the two, will be slow to render. Try to limit your access to these records.

			== Improvements Coming ==
			We have in our PubGizmo development plan a big update in the works that will cache sales data, instead of reading each sales record individually. This will yield a major performance improvement. Stand by for updates!

PubGizmoSysop at 18:24, 30 April 2025

2025-04-30T18:24:07Z

← Older revision		Revision as of 14:24, 30 April 2025
Line 1:		Line 1:
	Help! PubGizmo/FileMaker Pro is crashing! This is a frustrating and time-consuming occurrence, and we are sorry you are experiencing it.		== Help! PubGizmo/FileMaker Pro is crashing! ==
			This is a frustrating and time-consuming occurrence, and we are sorry you are experiencing it. There can be a variety of causes, some of which are us, some of which are you, and some to chalk up to the mysteries of computers and networks.
	There can be a variety of causes, some of which are us, some of which are you, and some to chalk up to the mysteries of computers and networks.

	== Is it a Crash or a Freeze/Stall? ==		== Is it a Crash or a Freeze/Stall? ==
	Firstly, we should distinguish between a crash and a freeze ~~or stall~~. These are different events, and require different handling.		Firstly, we should distinguish between a crash and a freeze. These are different events, and require different handling.

	=== Crash ===		=== Crash ===
	A crash means FileMaker Pro has quit. All windows have disappeared from the screen. There's no spinning beachball.		A crash means FileMaker Pro has quit. All windows have disappeared from the screen. There's no spinning beachball, no hourglass.

	On a Mac, you'll usually receive a dialogue that tells you FileMaker Pro has crashed, with a few options: re-open, report the problem to Apple, or cancel. If you look at the [https://support.apple.com/en-ca/guide/mac-help/mh35859/mac Dock], the icon is gone, or, if you keep it in the Dock, there's no black dot below the icon to indicate it's running.		On a Mac, you'll usually receive a dialogue that tells you FileMaker Pro has crashed, with a few options: re-open, report the problem to Apple, or cancel. If you look at the [https://support.apple.com/en-ca/guide/mac-help/mh35859/mac Dock], the icon is gone, or, if you keep the icon in the Dock, there's no black dot below the icon to indicate it's running.

	On Windows, it no longer appears on the [https://support.microsoft.com/en-us/windows/how-to-use-the-taskbar-in-windows-0657a50f-0cc7-dbfd-ae6b-05020b195b07#:~:text=Typically%2C%20the%20taskbar%20is%20at,the%20top%20of%20the%20desktop. Taskbar]. If you look at the [[wikihow:Open-Windows-Task-Manager#:~:text=Press%20Ctrl%20%2B%20Shift%20%2B%20Esc%20to,and%20select%20%22Task%20Manager.%22\|Task Manager]], FileMaker does not appear.		On Windows, it no longer appears on the [https://support.microsoft.com/en-us/windows/how-to-use-the-taskbar-in-windows-0657a50f-0cc7-dbfd-ae6b-05020b195b07#:~:text=Typically%2C%20the%20taskbar%20is%20at,the%20top%20of%20the%20desktop. Taskbar]. If you look at the [[wikihow:Open-Windows-Task-Manager#:~:text=Press%20Ctrl%20%2B%20Shift%20%2B%20Esc%20to,and%20select%20%22Task%20Manager.%22\|Task Manager]], FileMaker does not appear.

	=== Freeze ~~or Stall~~ ===		=== Freeze ===
	If FileMaker Pro is still running but unresponsive, it has frozen or stalled. There's a good chance it's still alive, but it has stalled, possibly because it is:		If FileMaker Pro is still running but unresponsive, it has frozen or stalled. There's a good chance it's still alive, but it has stalled, possibly because it is:

Line 19:		Line 18:
	# attempting to fetch a large volume of data from the server to display, or to calculate		# attempting to fetch a large volume of data from the server to display, or to calculate
	# struggling the negotiate a bad network connection		# struggling the negotiate a bad network connection
	# impeded ~~with~~ your computer's speed		# impeded by your computer's speed
	# struggling with a heavy server load		# struggling with a heavy server load (unlikely)

	==== Wait it Out ====		==== Wait it Out ====
	In this situation, you may just have to wait for PG to yield data and update – give it a chance to complete its processes, and your results will appear. It can take many seconds, or even many minutes, in extreme cases, to respond.		In this situation, you may just have to wait for PG to yield data and update – give it a chance to complete its processes, and your results will appear. It can take many seconds, or even many minutes, in extreme cases, to respond.

			===== Data Volume and/or Complexity =====
	Frequently, the nature of the operation you are trying to perform, or the volume or complexity of data you are trying to access, will help you understand why the freeze is happening.		Frequently, the nature of the operation you are trying to perform, or the volume or complexity of data you are trying to access, will help you understand why the freeze is happening.

Line 31:		Line 31:
	* Opening royalty statements with escalation and/or lots of sales records		* Opening royalty statements with escalation and/or lots of sales records
	* Using the Reporter with many of record selected, or covering a large span of time		* Using the Reporter with many of record selected, or covering a large span of time
	* Viewing records is List View, especially Royalties if the amount column is toggled on (PG must calculate royalties for all the statements in the view)		* Viewing records in List View, especially Royalties if the amount column is toggled on (PG must calculate royalties for all the statements in the view, which invokes hundreds or even thousands of calculations).

			== What to Do ==

			=== Crashes ===

			==== Isolated ====
			An isolated crash can be dismissed as a one-off. Computers crash, software crashes – we don't always know why. Just re-open FileMaker, connect to PubGizmo, and continue where you left off.

			==== Chronic ====
			If you are suffering chronic, not infrequent crashes, something more serious is going on. There are a host of possible causes, and solutions:

			===== Computer Problem =====
			Do other programs also crash? If yes, then the problem lies with your computer, either the hardware, or your operating system. Windows is more prone to this kind of issue that macOS. The best bet with either is a complete wipe and reinstall of your computer; it's not a trivial task, but it can yield significant improvements, not just in terms of crashing, but also computer speed. You can search for information on how to perform a wipe and reinstall. The most important step is to back up your data, since the "wipe" part involves deleting everything on your computer.

			If your problems survive a wipe/reinstall, it could be an issue with your computer hardware. This is best diagnosed by a professional.

			===== FileMaker Pro Application Problem =====
			If only FileMaker crashes, uninstall it, and reinstall. This will ensure that your installation of FileMaker is not corrupt.

			=== Freezes ===

			==== All Records, Operations ====
			If you experience freezes (PubGizmo eventually responds), and it doesn't seem to matter what you're looking at (e.g., just a basic Contact record), something is impeding the exchange of information between your computer and the data on the server. This could be:

	~~Viewing data on~~ a ~~popular title~~, i.e., ~~one with lots of sales records~~, can ~~cause FileMaker to freeze or stall~~		===== Poor Network Connection =====
			If your internet is slow, access to PubGizmo will be slow. You can check your speed by going to [https://speedtest.net speedtest.net] and running a test. Faster is better, but at a minimum your up and down speeds should exceed 10 Mbps. Your internet speed or your network connection (e.g., on WiFi, but weak signal) can impede network traffic. If you rectify these issues, things may improve.

	~~Your~~ computer ~~speed, your connection speed, and loading on the server~~ can ~~all affect~~		===== Slow Computer =====
			An old computer or a computer problem (corrupt OS) can impede access to PubGizmo.

PubGizmoSysop at 21:11, 23 November 2024

2024-11-23T21:11:28Z

← Older revision		Revision as of 17:11, 23 November 2024
Line 23:		Line 23:

	==== Wait it Out ====		==== Wait it Out ====
	In this situation, you may just have to wait for PG to yield data and update – give it a chance to complete its processes, and your results will appear.		In this situation, you may just have to wait for PG to yield data and update – give it a chance to complete its processes, and your results will appear. It can take many seconds, or even many minutes, in extreme cases, to respond.

			Frequently, the nature of the operation you are trying to perform, or the volume or complexity of data you are trying to access, will help you understand why the freeze is happening.

			For reference, these operations will be slow:

			* Opening royalty statements with escalation and/or lots of sales records
			* Using the Reporter with many of record selected, or covering a large span of time
			* Viewing records is List View, especially Royalties if the amount column is toggled on (PG must calculate royalties for all the statements in the view)

	~~Frequently, the nature of the operation you are trying to perform, or the data you are trying to access, will help you understand why the freeze is happening.~~

PubGizmoSysop: Created page with "Help! PubGizmo/FileMaker Pro is crashing! This is a frustrating and time-consuming occurrence, and we are sorry you are experiencing it. There can be a variety of causes, some of which are us, some of which are you, and some to chalk up to the mysteries of computers and networks. == Is it a Crash or a Freeze/Stall? == Firstly, we should distinguish between a crash and a freeze or stall. These are different events, and require different handling. === Crash === A crash..."

2024-11-23T20:59:27Z

Created page with "Help! PubGizmo/FileMaker Pro is crashing! This is a frustrating and time-consuming occurrence, and we are sorry you are experiencing it. There can be a variety of causes, some of which are us, some of which are you, and some to chalk up to the mysteries of computers and networks. == Is it a Crash or a Freeze/Stall? == Firstly, we should distinguish between a crash and a freeze or stall. These are different events, and require different handling. === Crash === A crash..."

New page

Help! PubGizmo/FileMaker Pro is crashing! This is a frustrating and time-consuming occurrence, and we are sorry you are experiencing it.

There can be a variety of causes, some of which are us, some of which are you, and some to chalk up to the mysteries of computers and networks.

== Is it a Crash or a Freeze/Stall? ==
Firstly, we should distinguish between a crash and a freeze or stall. These are different events, and require different handling.

=== Crash ===
A crash means FileMaker Pro has quit. All windows have disappeared from the screen. There's no spinning beachball.

On a Mac, you'll usually receive a dialogue that tells you FileMaker Pro has crashed, with a few options: re-open, report the problem to Apple, or cancel. If you look at the [https://support.apple.com/en-ca/guide/mac-help/mh35859/mac Dock], the icon is gone, or, if you keep it in the Dock, there's no black dot below the icon to indicate it's running.

On Windows, it no longer appears on the [https://support.microsoft.com/en-us/windows/how-to-use-the-taskbar-in-windows-0657a50f-0cc7-dbfd-ae6b-05020b195b07#:~:text=Typically%2C%20the%20taskbar%20is%20at,the%20top%20of%20the%20desktop. Taskbar]. If you look at the [[wikihow:Open-Windows-Task-Manager#:~:text=Press%20Ctrl%20%2B%20Shift%20%2B%20Esc%20to,and%20select%20%22Task%20Manager.%22|Task Manager]], FileMaker does not appear.

=== Freeze or Stall ===
If FileMaker Pro is still running but unresponsive, it has frozen or stalled. There's a good chance it's still alive, but it has stalled, possibly because it is:

# trying to run a complex calculation
# attempting to fetch a large volume of data from the server to display, or to calculate
# struggling the negotiate a bad network connection
# impeded with your computer's speed
# struggling with a heavy server load

==== Wait it Out ====
In this situation, you may just have to wait for PG to yield data and update – give it a chance to complete its processes, and your results will appear.

Frequently, the nature of the operation you are trying to perform, or the data you are trying to access, will help you understand why the freeze is happening.

Viewing data on a popular title, i.e., one with lots of sales records, can cause FileMaker to freeze or stall

Your computer speed, your connection speed, and loading on the server can all affect