I am experiencing frequent freezes in SQL Data Generator. I am using a trial version. My SQL Server 2016 DB has about 150 tables. About 100 of those tables have a field named ExtJSON, and these are generated with an IronPython script as shown in the code block below.
Frequently, especially when I'm typing text into the Find box at the top left, it starts generating a preview immediately, and freezes. I can not cancel (the cancel button just grays out when I click it.) One core on my PC is locked at 100% cpu, and I believe you have probably got an IronPython Eval(pythonScript) running, and it's not terminating. Memory usage is not very high (120 megs). I have to kill SQL data generator. I save frequently. But this bug is bad enough to make me rethink purchasing the product.
If I never ever use the Find(filter) box, this never happens. It always freezes while generating script data.
Screenshot:
Script:
# GENERATE A JSON STRING
import clr
#ironpython-style random:
from System import Random
random = Random()
def choice(alist):
i = random.Next(len(alist))
return alist[i]
def choices(spacer,alist,acount):
return spacer.join([choice(alist) for _ in range(acount)])
def randrange(min,max):
return random.Next(min,max)
def main(config):
return "{ "always": "+str(randrange(10,1000))+", ""+choices( "_", ["foo", "bar", "bat","baz","baf","min","max", "age", "id", "external","internal"], 2)+"": "+str(randrange(0,5000))+" }"
Hello Warren,
Frequently, especially when I'm typing text into the Find box at the top left, it starts generating a preview immediately, and freezes. I can not cancel (the cancel button just grays out when I click it.) One core on my PC is locked at 100% cpu, and I believe you have probably got an IronPython Eval(pythonScript) running, and it's not terminating. Memory usage is not very high (120 megs). I have to kill SQL data generator. I save frequently. But this bug is bad enough to make me rethink purchasing the product.
If I never ever use the Find(filter) box, this never happens. It always freezes while generating script data.
Screenshot:
Script:
# GENERATE A JSON STRING import clr #ironpython-style random: from System import Random random = Random() def choice(alist): i = random.Next(len(alist)) return alist[i] def choices(spacer,alist,acount): return spacer.join([choice(alist) for _ in range(acount)]) def randrange(min,max): return random.Next(min,max) def main(config): return "{ "always": "+str(randrange(10,1000))+", ""+choices( "_", ["foo", "bar", "bat","baz","baf","min","max", "age", "id", "external","internal"], 2)+"": "+str(randrange(0,5000))+" }"