[workaround] Help! Is anyone using pgBouncer?

Get Help and Help Others
1

Hi guys,

I’m hitting my first load issues with Supabase and they are asking if I am using pgBouncer – so I’m very interested in this right now as customers are seeing red errors…

Thanks
Al;

2

well now I’m just embarrassed :slight_smile:

3

Whelp, that didn’t help. Made it worse. I need to learn more.

4

No time, no time, no time !

I the process in question was being driven from the front end so I put a throttle on it by building a container that delays rendering [the cell that calls the database]

export const xPerSecond = (x, ndx) => (ndx / x) * 1000
const DelayedRender = ({ renderDelay, children }) => {
  const [waiting, setWaiting] = React.useState(true)
  React.useEffect(() => {
    setTimeout(() => {
      setWaiting(false)
    }, renderDelay)
  })
  if (waiting) {
    return (
      <span>Pending...</span>
    )
  }
  return children
}
export default DelayedRender

and used it

  const uploadingCells = uploadData.map((aRecord, ndx) => (
    <DelayedRender key={aRecord.id} renderDelay={xPerSecond(HOW_MANY_PER_SECOND, ndx)}>
      <UploadingAttendeeCell key={aRecord.id} eventId={eventId} input={aRecord} exfiltrate={() => anotherUploadDone(aRecord)} />
    </DelayedRender>
  ))
1 Like