View Single Post
Old 05-28-2009, 10:28 PM   #67 (permalink)
kengreenwood
Platinum Lifetime Member
 
kengreenwood's Avatar
 
Name: That shouldn't be too hard to figure out...
Last Online: 10-29-2009 08:46 AM
iTrader: (2)
Join Date: May 2006
Posts: 377
DNF$: 4,437
Location: Tampa
Country:


All - you should see a marked improvement in the performance of the ZFBot application. I've added a bunch of indexes on the large zone file table (over 100 million records on that table) and the searches are coming back quicker. I've noted that any search that yields a large number of domains tends to never come back - and that large number of records value is dependent on the memory on your local machine. There is no limitation on the number of records the datagrid can hold - it's just the memory on your machine. For example, on my laptop the queries that yield over 150,000 domains never come back for me... it may be higher or lower for each of you. I'm working on adding paging functionality to the datagrid that displays the resulting domains so that I can avoid the local machine memory issue and return an unlimited number of domains. For now, keep this in mind and just narrow down your searches by using the options of domain length, excluding dashes, numbers etc... and you'll be fine.

On a side note - I apologize for being out of pocket for the last couple weeks - I just sold my house and moved to a new one... hired a moving company for the big stuff but I moved a lot of stuff myself ... every bone/muscle in my body is aching... including my (typing) fingers. ouch.

5/29/09 11:10 AM - optimizing the large zfbot table right now ... queries will run endlessly until it's complete.. sorry!

OK - everything is kosher again. I removed the auto-search on load and replaced it with a welcome swf...

check it out... http://www.ZFBot.com
__________________
KJG
OneWorldMedia, ZFBot

Last edited by kengreenwood; 05-29-2009 at 03:18 PM.. Reason: Automerged Doublepost
kengreenwood is offline   Reply With Quote