MYSQL Querys

[PeterPan]

Hi there,

I've got a routine, that uses flat-file (text-based) files to record data/information..

I'm thinking of changing it into MYSQL, & have looked in the powweb knowledgebase & cannot locate this answer.

Basically, I have a script (scheduled task) that goes rvery 5 minutes, & updates 5 things to my index file each time.

I'm wondering, to do the same with MYSQL, & thinking of updating 20 items every 10 minutes (not 5 minutes)..


Q1) does anyone know how many queries an hour we can have ?

Currently, my script runs every 5 minutes, & does a process in about 1-2 seconds...

Q2)
If I change it to every 10 minutes, & increase the number of items indexed to 20, - will that be a bad thing for MYSQL..

EG - 20 queries in about 5 seconds, and then nothing - for the next 9.7 minutes etc - till the next task...

(I erase my master index file on a monthly basis, & it takes under 1 day, to re-index the files the 1st day, & then a few hours each day to index any updates...)

- if It goes the way I think, the MYSQL will take 1/3rd the time to index my files...

[jmucchiello]

Why would you delete the index every month if you moved it to a database?

Your questions are impossible to answer without more description of what you are really doing.

[kanwulf]

Q1)

I was told by tech on the phone that the new platform does NOT have an hourly query limit unlike the legacy platform. :)


I used to get disabled somewhat frequently even using all three available dbase user id's and since the migration I've put this claim to a pretty good test and no problems. I know we have had in excess of 100K queries in an hour through a single id without a problem