ARI Soft - Quiz Results will kill me

Home

News

Forum

Featured Demos

ARI Smart Content demo

ARI Quiz demo

ARI Sexy Lightbox demo

e-mail: info@ari-soft.com

Shopping Cart

Show Cart

Recent Events

29/12/2011 Merry Christmas and Happy New Year!

Dear visitors, our office will be closed from December 30 to January 2 due to the celebration of the New Year. You can purchase and download our products, but we can not guarantee quick answers to your questions for this period of time. Happy New Year! Your ARI Soft team.

more...
27/09/2011 ARI Smart Content v. 1.8.0

ARI Smart Content v. 1.8.0 is ready. New version is compatible with Joomla! 1.5, 1.6 and 1.7 and it is released under GNU GPL license.

more...

2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft.

Welcome, Guest
Please Login or Register. Lost Password?

ARI Soft Forum

Joomla components

ARI Quiz

Quiz Results will kill me

(1 viewing) (1) Guest

component

Page: 12

TOPIC: Quiz Results will kill me

Forum Tools

#6830

Quiz Results will kill me 1 Year, 5 Months ago	Karma: 1
Hi! Me kills periodically to clean Quiz Results by Delete All. It would be desirable to have a script (by php or perl) which can be caused using the scheduler of tasks.

Federico

The administrator has disabled public write access.

#6852

Re:Quiz Results will kill me 1 Year, 5 Months ago Karma: 276

Hello,

Usually hosting panel provides access to CRON (scheduler). And you can create task which will execute the following SQL query:

Code:



DELETE 

  S,SI 

FROM 

  jos_ariquizstatisticsinfo SI INNER JOIN jos_ariquizstatistics S

    ON SI.StatisticsInfoId = S.StatisticsInfoId

WHERE SI.`Status` = "Finished"

Regards,
ARI Soft

admin

The administrator has disabled public write access.

#9389

Re:Quiz Results will kill me 1 Year, 1 Month ago	Karma: 1
Hi! 1) Whether users can be tested during performance of this SQL query? Wouldn't it lead to an error? 2) This SQL query deletes data from tables. But their size increases every day!!! I have to use phpMyAdmin for deletion. It is uncomfortable! How can I change your SQL query? Best regards.

Federico

The administrator has disabled public write access.

#9446

Re:Quiz Results will kill me 1 Year, 1 Month ago Karma: 276

Hello,

1. Yes, you can execute this query, it doesn't affect on active quizzes sessions.

2. Try to execute the following SQL query, after query which deletes results:

Code:



OPTIMIZE TABLE jos_ariquizstatisticsinfo, jos_ariquizstatistics

You can read about "OPTIMIZE TABLE" here.

Regards,
ARI Soft

admin

The administrator has disabled public write access.

#10220

Re:Quiz Results will kill me 1 Year ago	Karma: 1
Hello, It became better. But the size of base increases. Regards.

Federico

The administrator has disabled public write access.

#10230

Re:Quiz Results will kill me 1 Year ago	Karma: 276
Hello, Could you specify increase size of specific table(s) or the whole database? "OPTIMIZE TABLE" statement should help to optimize database if it doesn't help it requires to investigate database configuration and tune it. Regards, ARI Soft

admin

The administrator has disabled public write access.

Page: 12

Useful Links