151 reputation
3
bio website docsalvage.info
location Tallahassee, FL
age 58
visits member for 1 year, 4 months
seen Mar 26 at 4:34

Unix/Linux software developer in dozens of languages since 1981 with 15 years in Oracle database design and administration.

Projects (most recent first)

  • Developing Zim desktop wiki (for notes) to GtkDialog conversion program to allow automatic creation of checklists for installs, etc. from Zim notes pages. Utilizes bash and 600+ line awk program.
  • Conversion from Tomboy/GNote to Zim for all writing.
    • Zim links to execute or edit scripts with Geany
  • Migrating from Ubuntu Linux to Puppy Linux due to dislike of Unity and Gnome3.
  • Save the world (or at least my sanity) by re-electing President Barak Obama and rescuing congress from the fanatics now running it.
    • 2012-11-06 DONE
      project scope change...
      part 2 improved but not completely doable at this time
  • JavaScript/jQuery-based composing and programming environment inspired by Jeremy Ruston's TiddlyWiki.

Jul
17
comment Mysql key_buffer_size already 16GB but some fulltext searches are still slow
This will sound counter-intuitive, but learned from working with large data with high demand a few years ago that buffers can be too big. Searching memory buffers usually does not use the highly-optimized-for-speed techniques employed for disk access as it's unnecessary. Today's memory buffers though are as big as disks of just a few years ago. There's a point of diminishing returns where a smaller buffer will actually be faster.
Jun
12
awarded  Supporter
Apr
17
answered Why are constraints applied in the database rather than the code?
Mar
27
awarded  Teacher
Mar
27
answered In what data type should I store an email address in database?
Nov
23
awarded  Autobiographer